分頁功能之SQL語法!
SELECT * FROM
(SELECT TOP 50 * FROM
(SELECT TOP 250 * FROM Products
ORDER BY ProductID) AS t1
ORDER BY ProductID DESC) AS t2
ORDER BY ProductID
(SELECT TOP 50 * FROM
(SELECT TOP 250 * FROM Products
ORDER BY ProductID) AS t1
ORDER BY ProductID DESC) AS t2
ORDER BY ProductID
標籤: SQL
0 Comments:
張貼留言
<< Home