sqlserver分页比较高效的一种方法

最新推荐文章于 2022-02-20 12:04:27 发布

wwwcomcn123

最新推荐文章于 2022-02-20 12:04:27 发布

阅读量757

点赞数

分类专栏： sqlserver

本文链接：https://blog.csdn.net/zhwwwcomcn123/article/details/38511527

版权

sqlserver 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

SELECT TOP 10 * 
FROM 
    (
        SELECT ROW_NUMBER() OVER (ORDER BY D.RECORD_ID) AS RowNumber,D.RECORD_ID,D.RECORD_VALUE,D.RECORD_TIME,M.CHECK_PROJECT FROM DATA_RECORD_HISTORY D INNER JOIN MONITOR M ON(D.MONITOR_ID=M.MONITOR_ID)
				WHERE M.MONITOR_ID=1
    ) AS TEMP
WHERE TEMP.RowNumber > 0

比

SELECT TOP 10 * FROM DATA_RECORD_HISTORY D INNER JOIN MONITOR M ON(D.MONITOR_ID=M.MONITOR_ID) WHERE M.MONITOR_ID=1 AND D.RECORD_ID 
	NOT IN(SELECT TOP 10 DD.RECORD_ID FROM DATA_RECORD_HISTORY DD INNER JOIN MONITOR MM ON(DD.MONITOR_ID=MM.MONITOR_ID) WHERE MM.MONITOR_ID=1)

高效！

并且下面这条语句的条件必须在两条select语句中都带着！在多条件分页查询中不是很方便。