clwn.net
当前位置:首页 >> orAClE使用wm_ConCAt后,对结果排序问题 >>

orAClE使用wm_ConCAt后,对结果排序问题

select str from ( select wm_concat(t.id) over( order by t.id) str,row_number() over( order by t.id desc) rn from student t) a where a.rn=1

select wm_concat(a.NAME) from( select a.id as aid,a.NAME from A a,B b start with a.ID=b.ID connect by prior a.PID=a.ID order by a.id asc ) a 试试这个。

WMSYS.WM_CONCAT(目标字段)over(partition BY 分组 order by 排序)

select t.* from(SELECT WM_CONCAT(DT) AS MASSAGE , NAME FROM AUNION ALLSELECT WM_CONCAT(DT) AS MASSAGE,NAME FROM B) torder by name

网站首页 | 网站地图
All rights reserved Powered by www.clwn.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com