oracle迭代 并将节点按某个顺序排序

来源:互联网 发布:淘宝买家旺旺采集 编辑:程序博客网 时间:2024/06/03 21:52

select * from jyjc.DANWEI dw start with dw.id in  (select dw.id from jyjc.DANWEI dw where dw.danwei is null ) connect by prior dw.id = dw.danwei order siblings by dw.diqu

原创粉丝点击