【2016-11-7】【坚持学习】【Day22】【Oracle 递归查询】

直接在oracle 递归查询语句

select * from groups start with id=:DeptId connect by prior superiorid =id

 

往下找

select * from groups start with id=:DeptId connect by prior id=superiorid

 

posted @ 2016-11-07 14:27  zscmj  阅读(151)  评论(0)  编辑  收藏  举报