oracle树形结构相关查询

查询最顶层元素

www.2cto.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'