Oracle 行转列 1.listagg() WITHIN GROUP () 示例数据图 将taskid相同的entname在一行显示 代码如下: SELECT taskid, listagg(d.ENTNAME, ',') WITHIN GROUP(ORDER BY d .LASTDATE) names FROM test_entinfo d group by d.taskid