SQL递归查询(with cte as)
摘要：
with cte as( select Id,Pid,DeptName,0 as lvl from Department where Id = 2 union all select d.Id,d.Pid,d.DeptName,lvl+1 from cte c inner j... 阅读全文
posted @ 2014-09-25 16:56 王大王 阅读(257) 评论(0) 推荐(0)
posted @ 2014-09-25 16:56 王大王 阅读(257) 评论(0) 推荐(0)
浙公网安备 33010602011771号