1 select top m-n+1 * from table where ID not in (select top n-1 ID from table)
2 Select * From
(Select Top M-N+1 * From
(Select Top M * From Tablec order by ID asc)T
Order By ID Desc) TT Order By ID
或者如下方式:
语法:
SELECT * FROM
(
SELECT TOP [每页记录] * FROM
(
SELECT TOP [每页记录*当前页数] [字段1, 字段2, ...]
FROM [数据表]
ORDER BY [排序字段] DESC
)
[表别名1]
ORDER BY [排序字段]
)
[表别名2]
ORDER BY [排序字段] DESC
示例:
SELECT * FROM
(
SELECT TOP 5 * FROM
(
SELECT TOP 10 *
FROM table
ORDER BY id DESC
) t1
ORDER BY id
) t2
ORDER BY id DESC
2 Select * From
(Select Top M-N+1 * From
(Select Top M * From Tablec order by ID asc)T
Order By ID Desc) TT Order By ID
或者如下方式:
语法:
SELECT * FROM
(
SELECT TOP [每页记录] * FROM
(
SELECT TOP [每页记录*当前页数] [字段1, 字段2, ...]
FROM [数据表]
ORDER BY [排序字段] DESC
)
[表别名1]
ORDER BY [排序字段]
)
[表别名2]
ORDER BY [排序字段] DESC
示例:
SELECT * FROM
(
SELECT TOP 5 * FROM
(
SELECT TOP 10 *
FROM table
ORDER BY id DESC
) t1
ORDER BY id
) t2
ORDER BY id DESC