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