一、查询语法: select column1,listagg(column2,',') within group (orderby column3) as column4... from tableName1
注意:oracle11g以上才支持此查法
1.listagg例子:
select senc_orgid ,senc_orgname,securname,securid ,depusecurname,depusecurid ,commebname,commebid, securlevname, depusecurlevname from (
select orgT.senc_orgid ,orgT.senc_orgname,count(senc_orgid) brannum from (
select t1.id senc_orgid,t1.org_name senc_orgname,t3.id thrd_orgid , t3.thrd_orgname from t_Pb_Organization t1 ,( select t2.id,t2.org_name thrd_orgname ,t2.pid from t_Pb_Organization t2 ) t3 where (t1.id=t3.pid or (t1.id=t3.id and t1.pid=2) ) and t1.pid !=0 and t1.isdeleted='0' order by t3.id
)