看看这个SQL语句的功能!
数据库:DB2
SQL语句:with v_1(company_no,company_supercn) as
(select company_no,company_supercn from t_company
where company_no='00019'
union all
select a.company_no,a.company_supercn from t_company a,v_1 b
where b.company_supercn=a.company_no)
select * from v_1