oracle--合并行数据

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

合并前效果：

 

合并后效果：