connect by sql 博客分类： 数据库 SQL

一种SQL:

select id, level 
from tree t 
start with t.parent_id = 0 
connect by prior t.id = t.parent_id;