所谓的潇洒

摘要： 通过递归查询部门id为11的部门及其子孙部门 with dep as (select * from department where dptid=11union all select d.* from Department d inner join dep p on d.DptParentID=p. 阅读全文