MSSQL的递归查询
摘要:
通过递归查询部门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. 阅读全文
posted @ 2022-02-09 15:13 所谓的潇洒 阅读(181) 评论(0) 推荐(0) 编辑