Orcale數據庫分頁代碼

數據庫分頁代碼

​
--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；


​