By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table mytable (
id int,
name varchar(20),
no varchar(20)
);
insert into mytable values
(123, 'aaa', '1,2,3'),
(124, 'aaa', '4,5,6'),
(125, 'aaa', '7,8,9');
Records: 3 Duplicates: 0 Warnings: 0
select min(id) as id, name, group_concat(no ORDER BY id ASC) as no
from mytable
group by name
| id | name | no |
|---|---|---|
| 123 | aaa | 1,2,3,4,5,6,7,8,9 |