SQL server
故丶
一个搬砖的程序猿
展开
-
递归查询
对数据库进行分页查询 --sql sever 递归查询部门及部门下级 WITH depart AS ( SELECT A_DepartmentId from [A_Department] where A_DepartmentId = 9--需要查找的部门节点 UNION ALL SELECT [A_Department].A_DepartmentId from depart JOIN [A_Department] on depart.A_DepartmentId = .原创 2021-02-23 09:19:11 · 463 阅读 · 0 评论 -
SQL
对数据库进行分组查询 --sql sever 分页查询 select * from (select row_number() over(order by p.Id) rownum,* from TABLE_NAME p) a where rownum between 1 and 10 原创 2019-05-21 12:05:51 · 1036 阅读 · 0 评论