2006/07/12

分頁功能之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

標籤:

0 Comments:

張貼留言

<< Home