2019獨角獸企業重金招聘Python工程師標準>>>

WMSYS.WM_CONCAT() ?拼接字符串以逗號分隔

SQL> select * from idtable;

??????? ID NAME
---------- ------------------------------
??????? 10 ab
??????? 10 bc
??????? 10 cd
??????? 20 hi
??????? 20 ij
??????? 20 mn

SQL> select id,wmsys.wm_concat(name) name from idtable
? 2? group by id;

??????? ID NAME
---------- --------------------------------------------------------------------------------
??????? 10 ab,bc,cd
??????? 20 hi,ij,mn

select t1.projectid , WMSYS.WM_CONCAT(case when role = '0' then accountid end) over(order by?projectid?)?test1 ,WMSYS.WM_CONCAT(decode(t.role, '1', t.accountid)) test2 , WMSYS.WM_CONCAT(t.accountid) acc from PROJECTACCOUNT t, PROJECT t1 where t.projectid = t1.projectid group by t1.projectid?

參考:http://blog.csdn.net/yy_mm_dd/article/details/3182953

轉載于:https://my.oschina.net/u/1458291/blog/298785

總結

以上是生活随笔為你收集整理的oralce group by字符串拼接的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。