原始数据:
聚合后结果:
oracle:
listagg() within group()函数
SELECT card.OPERLINEID,listagg(card.VEHICLENO,',') within group (order by card.OPERLINEID) vehicles
FROM dlysjhsj.SD_PUBLIC_L1_LINECARD card
GROUP BY card.OPERLINEID
Mysql:
group_concat()函数
SELECT card.OPERLINEID,group_concat(card.VEHICLENO)
FROM dlysjhsj.SD_PUBLIC_L1_LINECARD card
GROUP BY card.OPERLINEID