PostgreSQL和MSSQL的区别
摘要：序号 不同点 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
阅读全文
posted @ 2022-02-11 14:05
02 2022 档案
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
