摘要:
排序: SELECT LISTAGG(column_name, ',') WITHIN GROUP (ORDER BY column_name) AS concatenated_string FROM your_table; 不排序: wmsys.wm_concat('{'||sceneName|| 阅读全文
摘要:
SELECT * FROM ORGANIZE -- START WITH PARENT_ID = 28001-- CONNECT BY PRIOR PARENT_ID = TID 父级: SELECT * FROM ORGANIZE START WITH TID = 28001CONNECT BY 阅读全文