wm_concat列转行排序问题
- 2017-03-28 17:41:00
- 1147533288 原创
- 1185
select cityid, max(r)
from (select cityid, dbms_lob.substr(wm_concat(year) over (partition by cityid order by year)) as r from new_resources)
group by cityid;
文章分类
联系我
| 联系人： | meepo |
|---|---|
| 电话： | ***** |
| Email： | 1147533288@qq.com |
| QQ： | 1147533288 |