1.需求
处理前: 多行合并后:
2.实现
select LISTAGG(begindate,chr(13)) WITHIN GROUP (ORDER BY begindate desc) from hi_psndoc_work where pk_psndoc=‘000111100000000JJO4Z‘
备注:Excel替换“换行”:Ctrl+J (笔记本)
2022-07-28 15:25:42
处理前: 多行合并后:
select LISTAGG(begindate,chr(13)) WITHIN GROUP (ORDER BY begindate desc) from hi_psndoc_work where pk_psndoc=‘000111100000000JJO4Z‘
备注:Excel替换“换行”:Ctrl+J (笔记本)