DB2 数据库之数据打平函数

select num,

       listagg(DSCR, ',') WITHIN GROUP(ORDER BY DSCR) as DSCR

from DWDM2.QUOTE_TEMP

 where DSCR != 'E0003'
 group by num with ur;