关于#sql#的问题：怎么将下面的数据按逗号分隔成多行，以列的形式展示出来

请问，怎么将下面的数据按逗号分隔成多行，以列的形式展示出来

想要这样的结果

https://www.cnblogs.com/dwuge/p/5261256.html
纯搬运，，，你把参数改一下就直接能用

WITH T1 AS (SELECT 01 AS id , '20220701' DT , 'T' TYPE UNION ALL
SELECT 01 AS id , '20220801' DT , 'F' TYPE UNION ALL
SELECT 01 AS id , '20220802' DT , 'T' TYPE UNION ALL
SELECT 02 AS id , '20220803' DT , 'T' TYPE UNION ALL
SELECT 02 AS id , '20220802' DT , 'T' TYPE UNION ALL
SELECT 03 AS id , '20220808' DT , 'F' TYPE )
SELECT CONCAT_WS(',',collect_set(RO)), group_concat(RO) FROM (
Select ID,TYPE,ROW_NUMBER()OVER(PARTITION BY '1' ORDER BY '1' ) RO
FROM T1 ) a