SQL分页语句

--前提是必需有一列是自动增长类型,唯一性

--方法一

SELECT DISTINCT TOP 8 CategoryID

FROM tbl_Product_Products

WHERE (UserID = 73) AND (CategoryID >

(SELECT MAX(categoryid)

FROM (SELECT DISTINCT TOP 16 categoryid

FROM tbl_product_products where userid=73

ORDER BY categoryid) AS b))

ORDER BY CategoryID

--方法二

select top 10 * from [order details]

where orderid>all(select top 10 orderid from [order details] order by orderid)

order by orderid