WITH子句的递归查询

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

WITH RPL AS
(
SELECT FId,FNumber,FName,FManagerId
FROM T_Person
WHERE FManagerId IS NOT NULL
)
SELECT FId,FNumber,FName,FManagerId FROM RPL