关于Oracle

来源:互联网 发布:安广网络电视怎么缴费 编辑:程序博客网 时间:2024/05/17 23:45

列转行函数:WM_CONCAT

select SC.ID, SC.BUSINESS_TYPE, SC.SEND_TYPE, AV.VAL BTYPENAME,WM_CONCAT(SCD.USER_ID)  USERAPPEND

from x1 sc
left join x2 scd on sc.id = scd.SEND_ID
left join x3 av on av.NAME = sc.BUSINESS_TYPE
group by SC.ID, SC.BUSINESS_TYPE, SC.SEND_TYPE, AV.VAL
0 0
原创粉丝点击