WITH子句的递归查询 2015/02/03 14152 WITH RPL AS ( SELECT FId,FNumber,FName,FManagerId FROM T_Person WHERE FManagerId IS NOT NULL ) SELECT FId,FNumber,FName,FManagerId FROM RPL