MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `test` (
  `id` int(11) NOT NULL,
  `name` varchar(10) DEFAULT NULL,
  `data-01` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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-01


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-01` order by `data-01` 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-01` order by `data-01` 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-01` order by `data-01` 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-01` order by `data-01` 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-01` SEPARATOR ',' ) as combdata
from test
group by name


name
combdata


jam
222,111

lili
456,123,777

lulu
789