withas递归 id|parentid|Code 1|null|S1409110001 2|1|S1409170004 3|2|S1409170006 无 with accountrp AS( SELECT TOP 1 uid,uaccountrpid,ccode from t_accountrp where ccode='S1409170006' UNION ALLSELECT t_accountrp.uid,t_accountrp.uaccountrpid,t_a
with as 递归with accountrp AS( SELECT TOP 1 uid,uaccountrpid,ccode from t_accountrp where ccode='S1409170006' UNION ALL SELECT t_accountrp.uid,t_accountrp.uaccountrpid,t_accountrp.ccode from accountrp inner join t_accountrp on accountrp.uaccountrpid=t_accountrp.uid )select * from accountrp ORDER BY ccode;
