sql心得

分类: IT文章 • 2022-08-21 15:16:32

sql经验

1.树

select 2009 + (level - 1) from dual connect by level <= 12

2.递归

找小弟
select *
from t_sys_org start with orgid in (select orgid from t_sys_org where name ='广州技术开发服务中心')
connect by prior orgid=orgpid

找大哥
select *
from t_sys_org start with name ='广州技术开发服务中心'
connect by prior orgpid=orgid and orgpid = '9999999999999999999'