准备数据:
create table test(
n varchar2(20),
m varchar(20)
);
insert into test values ('0', '1');
insert into test values ('1', '1');
insert into test values ('10', '1');
insert into test values ('11', '1');
insert into test values ('2', '2');
insert into test values ('7', '2');
insert into test values ('12', '2');
insert into test values ('17', '2');
insert into test values ('3', '3');
insert into test values ('5', '3');
insert into test values ('13', '3');
insert into test values ('15', '3');
insert into test values ('6', '5');
insert into test values ('16', '5');
sql:
select m, max(r)
from (select m, wm_concat(n) over (partition by m order by n) r from test)
group by m ;
备注:在oracle下可以直接执行。