---用逗号隔开查询数据 两种方式 select wmsys.wm_concat(name) from table_name; SELECT xType, ListAgg(to_char(City),',') WITHIN GROUP(ORDER BY xType) AS xCity FROM MyTest GROUP BY xType
---用逗号隔开查询数据 两种方式 select wmsys.wm_concat(name) from table_name; SELECT xType, ListAgg(to_char(City),',') WITHIN GROUP(ORDER BY xType) AS xCity FROM MyTest GROUP BY xType
转载于:https://www.cnblogs.com/flatwang/p/10083172.html