日期:2014-05-16  浏览次数:20498 次

oracle树形结构相关查询

查询最顶层元素

?

select * from basic_type t WHERE NOT exists(select 'x' from basic_type t1,basic_type t2 where t1.id=t2.parentid and t1.id= t.parentid)

?

查询id为'asdfas'的属于顶层ID为4的第几级

?select * from (select LEVEL,id,parentid,name from basic_type START WITH id='4'?
?? CONNECT BY PRIOR id=parentid) where id= 'asdfas'