oracle 分组合并行

不同时间发上来的短信按顺序合并成一条完整的短信

 

select * from messages m where m.cardid=29 order by m.sendtime desc;
select m.groupvalue,max(sendtime) as sendtime,listagg(m.content) within group (order by sort) as content
from messages m where m.cardid=29
--and m.groupvalue='1393f3e2-d2c3-46e2-8297-60df629bbba4'
group by m.groupvalue order by sendtime desc;