06 2023 档案

Oracle列转行函数LISTAGG() WITHIN GROUP ()用法
摘要：1：SELECT ID, SID FROM Test WHERE ID ='001' 2：SELECT ID,LISTAGG(SID, ',') WITHIN GROUP (ORDER BY SID) AS SID_LIST FROM Test WHERE ID ='001' group by ID 阅读全文
posted @ 2023-06-19 17:19 似曾相识燕归来 阅读(203) 评论(0) 推荐(0) 编辑