oracle，在一条sql语句里面的wmsys.wm_concat()、row_number()、union all 的用法

本文主要是介绍oracle，在一条sql语句里面的wmsys.wm_concat()、row_number()、union all 的用法，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

select a.plan_id,'补充说明：' || a.contents as caozuo,' ' as remarks,a.create_on,a.create_byfrom PROMOTION_PLAN_SUPPLEMENT awhere a.plan_id = '28bae9cc089a446db7264a9ba7a71a75'
union all
select plan_id, '归还服务：' || fwRecord, remarks, modifed_on, modifed_byfrom (select plan_id,wmsys.wm_concat(fwRecord) over(partition by modifed_by, modifed_on) as fwRecord,row_number() over(partition by modifed_by, modifed_on order by modifed_on desc) rn1,remarks,modifed_on,modifed_byfrom (select plan_id,item_name || '*' || count_num as fwRecord,remarks,modifed_on,modifed_byfrom (select plan_id,item_name,remarks,modifed_on,modifed_by,row_number() over(partition by item_name, modifed_on, modifed_by order by modifed_on desc) rn,count(item_name) over(partition by item_name, modifed_on, modifed_by) count_numfrom (select p.plan_id,fw.item_name,p.remarks,p.modifed_on,p.modifed_byfrom (select b.plan_id,b.fw_id,b.remarks,b.modifed_on,b.modifed_byfrom promotion_fw_record bwhere b.fw_record_status = '2'and b.plan_id ='28bae9cc089a446db7264a9ba7a71a75') pleft join (select t2.id, t1.item_namefrom fw_item        t1,fw_guajie_item t2where t1.id = t2.fw_item_id) fwon p.fw_id = fw.id))where rn = 1))where rn1 = 1order by create_on desc

这篇关于oracle，在一条sql语句里面的wmsys.wm_concat()、row_number()、union all 的用法的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---