分页方案一:(利用Not In和SELECT TOP分页)
语句形式:
SELECT
TOP
页大小
*
FROM TestTable
WHERE (ID NOT IN
( SELECT TOP 页大小 * 页数 id
FROM 表
ORDER BY id))
ORDER BY ID
FROM TestTable
WHERE (ID NOT IN
( SELECT TOP 页大小 * 页数 id
FROM 表
ORDER BY id))
ORDER BY ID
-------------------------------------
分页方案二:(利用ID大于多少和SELECT TOP分页)
SELECT
TOP
页大小
*
FROM TestTable
WHERE (ID >
( SELECT MAX (id)
FROM ( SELECT TOP 页大小 * 页数 id
FROM 表
ORDER BY id) AS T))
ORDER BY ID
FROM TestTable
WHERE (ID >
( SELECT MAX (id)
FROM ( SELECT TOP 页大小 * 页数 id
FROM 表
ORDER BY id) AS T))
ORDER BY ID