with cte as
(
select Id,Pid,DeptName, 0 as lvl from Department select Id,Pid,DeptName, 0
阅读背景：
sql语句查询下级下下级
来源：互联网
with cte as
(
select Id,Pid,DeptName, 0 as lvl from Department select Id,Pid,DeptName, 0
分享到：
