表: cq_lowva_increment
LOAD_ID MONTHLY
1 2
1 3
2 5
2 1
希望样式:
LOAD_ID OM
1 2,3
2 5,1
SELECT load_id,LISTAGG(monthly_total, ',') WITHIN GROUP (ORDER BY monthly_total) AS OM from (select * from cq_lowva_increment where elecity_guid ='81a0aa29-cb15-459c-8ca3-8bd5de4aa63d' order by load_id ,month) GROUP BY load_id ;