高效分页

最新推荐文章于 2024-10-30 09:19:21 发布

qq_37985261

最新推荐文章于 2024-10-30 09:19:21 发布

阅读量246

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/qq_37985261/article/details/80423389

SELECT  TOP 15 * FROM (SELECT ROW_NUMBER () OVER (ORDER BY VDepartAdminPower.ID DESC) AS rownumber,VDepartAdminPower.*FROM 
VDepartAdminPower
 WHERE  (  [DepartRelationId] like '%201608031119253248-959b-4vzj4v%' ) and RealName not In (select cusname from Sys_Customer where cusid='201607291017326856-99fb-p6zx68')
  and cusid='201607291017326856-99fb-p6zx68'  ) AS row
  WHERE
rownumber > CAST (15 AS INT) * (CAST(2-1 AS INT))