2015年3月31日
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 jo... 阅读全文
posted @ 2015-03-31 10:54 金凤 阅读(197) 评论(0) 推荐(0)