MSSQL：
select * from ( select TOP size * FROM ( SELECT TOP (start*size) * from table_name ORDER BY BY id ASC ) as aSysTable ORDER BY id DESC ) as bSysTable ORDER BY id ASC
size:每次獲取的記錄數(shù)
start:請求的頁數(shù)
MySQL（SQLLite分頁也和MySQL一樣）：
select * from table_name limit start,pageNum
start:取數(shù)據(jù)的定位點(diǎn) [開始是從0開始]
pageNum：每次取多少
比如:start=0|ageNum=5
那么就是說，取1-6 條數(shù)據(jù)
Oracle：
SELECT * FROM (SELECT a.*, ROWNUM row_num FROM ( table_name ) a) b
WHERE b.row_num BETWEEN 1 AND 3
這是取table_name第一到第三條記錄
posted on 2010-12-02 11:13
sanmao 閱讀(167)
評論(0) 編輯 收藏