摘要:
不同时间发上来的短信按顺序合并成一条完整的短信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 阅读全文