oracle中与mysql中group concat同样作用的函数
LISTAGG(ID, ',') WITHIN GROUP(ORDER BY ID) AS ids
-- 示例
select CHANNEL_ID, LISTAGG(ID, ',') WITHIN GROUP(ORDER BY ID) AS ids
from EDU_APP_CHANNEL_POSITION group by CHANNEL_ID
oracle中与mysql中group concat同样作用的函数
LISTAGG(ID, ',') WITHIN GROUP(ORDER BY ID) AS ids
-- 示例
select CHANNEL_ID, LISTAGG(ID, ',') WITHIN GROUP(ORDER BY ID) AS ids
from EDU_APP_CHANNEL_POSITION group by CHANNEL_ID