select
top
页大小
*
from table1
where id >
( select max (id) from
( select top ((页码 - 1 ) * 页大小) id from table1 order by id) as T
)
order by id
from table1
where id >
( select max (id) from
( select top ((页码 - 1 ) * 页大小) id from table1 order by id) as T
)
order by id
从publish 表中取出第 n 条到第 m 条的记录:
SELECT
TOP
m
-
n
+
1
*
FROM publish
WHERE (id NOT IN
( SELECT TOP n - 1 id
FROM publish))
FROM publish
WHERE (id NOT IN
( SELECT TOP n - 1 id
FROM publish))
SELECT
TOP
页大小
*
FROM Table1
WHERE not exists
( select * from ( select top (页大小 * 页数) * from table1 order by id) b where b.id = a.id )
order by id
FROM Table1
WHERE not exists
( select * from ( select top (页大小 * 页数) * from table1 order by id) b where b.id = a.id )
order by id