所谓的潇洒

摘要：序号 不同点 MS PG 说明 1 delete 可以省略from 联表删除：delete ta from ta a inner join tb b on 不可省略from 联表删除：delete from ta a using tb b where 2 insert 可以省略into 不可以省略i 阅读全文

摘要：通过递归查询部门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. 阅读全文