MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test 
(
id int,
name  nvarchar(10),
data nvarchar(10)
);

insert into test
values
(1,'lili','456'),
(2,'lili','123'),
(3,'lulu','789'),
(4,'jam','222'),
(5,'lili','777'),
(6,'jam','111');

select *
from test;


id
name
data


1
lili
456

2
lili
123

3
lulu
789

4
jam
222

5
lili
777

6
jam
111


-- group_concat : case 1
select name,group_concat(data order by data SEPARATOR ',' ) as combdata
from test
group by name
order by name


name
combdata


jam
111,222

lili
123,456,777

lulu
789


-- group_concat : case 2
select name,group_concat(data order by data SEPARATOR ',' ) as combdata
from test
group by name
order by name desc


name
combdata


lulu
789

lili
123,456,777

jam
111,222


-- group_concat : case 3
select name,group_concat(data order by data desc SEPARATOR ',' ) as combdata
from test
group by name
order by name 


name
combdata


jam
222,111

lili
777,456,123

lulu
789


-- group_concat : case 4
select name,group_concat(data order by data desc SEPARATOR ',' ) as combdata
from test
group by name
order by name desc


name
combdata


lulu
789

lili
777,456,123

jam
222,111


-- group_concat : case 5
select name,group_concat(data SEPARATOR ',' ) as combdata
from test
group by name


name
combdata


jam
222,111

lili
456,123,777

lulu
789