oracle树形结构相关查询

oracle树形结构相关查询

 

查询最顶层元素

   www.zzzyk.com  

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'