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:請(qǐng)求的頁(yè)數(shù)
MySQL（SQLLite分頁(yè)也和MySQL一樣）：
select * from table_name limit start,pageNum
start:取數(shù)據(jù)的定位點(diǎn) [開(kāi)始是從0開(kāi)始]
pageNum：每次取多少
比如:start=0|ageNum=5
那么就是說(shuō)，取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 閱讀(174)
評(píng)論(0) 編輯 收藏