oracle--合并行数据

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

select  to_char(wmsys.wm_concat(patname)) as WaitPatientName from     (SELECT *           FROM (SELECT ROW_NUMBER() OVER(PARTITION BY cc.queuename ORDER BY cc.enroldate) rn,                 cc.*                 FROM          (select * from (select a.patname,a.queuesign,a.queuename,a.enroldate,a.status from qs_register a where a.status='已登记' group by a.patname,a.queuesign,a.queuename,a.enroldate,a.status order by a.queuename,a.enroldate,a.status) bb)cc          )          WHERE rn in(1,2,3)   ) temp   group by queuename

合并前效果：

 

合并后效果：