1、listagg或wm_concat查询出来没有数据,首先确保是否存在数据,其次检测下要合并的字段是否为nvarchar2,如果是这个字段话要进行下to_char转换,不然查出来的是空白
LISTAGG( to_char(Item_Category_Name), ',') WITHIN GROUP(ORDER BY Item_Category_Name) -- 将 Item_Category_Name 列的内容以", "进行分割合并、排序;
例子:select r.buildingid, wm_concat(r.roomname) as listname, count(r.buildingid) from room r group by r.buildingid
select r.buildingid, LISTAGG( to_char(r.roomname), ',') WITHIN GROUP(ORDER BY r.roomnum) as listname, count(r.buildingid) from room r group by r.buildingid
记过数据如下所示: