with as 递归
- 作者: -白娘子-
- 来源: 51数据库
- 2022-08-17
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;
推荐阅读
