作者:我家在波力牧场 | 来源:互联网 | 2018-07-10 14:56
方法一:SELECTTOP页大小*FROMtable1WHEREidNOTIN(SELECTTOP页大小*(页数-1)idFROMtable1ORDERBYid)ORDERBYid
方法一: SELECT TOP 页大小 *FROM table1WHERE id NOT IN(SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id)ORDER BY id
方法一:
SELECT TOP 页大小 *
FROM table1
WHERE id NOT IN
(
SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id
)
ORDER BY id
,