oracle-listagg行转列汇总
select rul_no,listagg(data_dt,',' ) within group(order by data_dt) fd1,listagg(data_dt,',' ) within group(order by data_dt desc) fd2from upsr.ntm_rul_ctlwhere rul_no='H02205'group by rul_no数据表如下 ：
1 | H02205 | 20210331 |
2 | H02205 | 20210430 |
3 | H02205 | 20210731 |
4 | H02205 | 20211031 |
结果1
1 | H02205 | 20210331,20210430,20210731,20211031 |
结果2，desc
1 | H02205 | 20211031，20210731,20210430,20210331 |
2022-7-29
| 留言与评论（共有 0 条评论） “” |
