數據庫分頁代碼
--Oracle 分頁代碼
--p.rownumber > pageNumber*pageSize
--ROWNUM <= pageSize
SELECT *
FROM (SELECT ROW_NUMBER () OVER (ORDER BY t.column) AS rownumber, t.*
FROM ( table ) t) p
WHERE p.rownumber > 10 AND ROWNUM <= 10;
--SQL Server分頁語句
--p.rownumber > pageNumber*pageSize
--top pageSize
SELECT top 10 *
FROM (SELECT ROW_NUMBER () OVER (ORDER BY t.column) AS rownumber, *
FROM table t) p
WHERE p.rownumber > 20;