表中主键必须为标识列
,[ID] int IDENTITY (1,1)
语句形式:
SELECT TOP 10 *
FROM TestTable
WHERE (ID NOT IN
( SELECT TOP 20 id
FROM TestTable
ORDER BY id))
ORDER BY ID
SELECT TOP 页大小 *
FROM TestTable
WHERE (ID NOT IN
( SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id))
ORDER BY ID
语句形式:
SELECT TOP 10 *
FROM TestTable
WHERE
1.分页方案一:(利用Not In和SELECT TOP分页)
语句形式:
SELECT TOP 10 *
FROM TestTable
WHERE (ID NOT IN
( SELECT TOP 20 id
FROM TestTable
ORDER BY id))
ORDER BY ID
SELECT TOP 页大小 *
FROM TestTable
WHERE (ID NOT IN
( SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id))
ORDER BY ID
2.分页方案二:(利用ID大于多少和SELECT TOP分页)
语句形式:
SELECT TOP 10 *
FROM TestTable
WHERE