SELECT TOP 页大小 *
FROM table1
WHERE id NOT IN
(
SELECT TOP (页大小*(页数-1) )id FROM table1 ORDER BY id
)
FROM table1
WHERE id NOT IN
(
SELECT TOP (页大小*(页数-1) )id FROM table1 ORDER BY id
)
ORDER BY id
例子:
SELECT TOP 5 sc.id,sj.name,sc.problem,sc.option1,option2,option3,option4,answer
FROM t_singleChoice sc,t_subject sj
WHERE id NOT IN
(
SELECT TOP (5*(3-1)) id FROM t_singleChoice ORDER BY id
)
ORDER BY id