oracle SQL
--子查父
select * from man_menue_hg m
start with m.m
connect by prior m.par_mid = m.mid;
--父查子
select * from man_menue_hg m
start with m.par_mid = '0'
connect by prior m.mid = m.par_mid
- 上一篇 »Oracle数据库查询分页SQL语句
- 下一篇 »Oracle数据库之PL/SQL异常处理
--子查父
select * from man_menue_hg m
start with m.m
connect by prior m.par_mid = m.mid;
--父查子
select * from man_menue_hg m
start with m.par_mid = '0'
connect by prior m.mid = m.par_mid