|
數(shù)據(jù)庫(kù)分頁(yè)語(yǔ)句使用：
1.Oracle:
select * from ( select row_.*, rownum rownum_ from ( query_SQL ) row_ where rownum =< max) where rownum_ >= min
2.SQL Server: select top @pagesize * from tablename where id not in
(select top @pagesize*(@page-1) id from tablename order by id) order by id 3.MySQL
select * from tablename limit position, counter
4.DB2
select * from (select *,rownumber() as ROW_NEXT from tablename) where ROW_NEXT between min and max
歡迎網(wǎng)友回帖補(bǔ)充！
出自 51CTO.COM博客 |
|
|
來(lái)自： 徐勇 > 《商業(yè)智能》
