几种流行的数据库SQL分页

hp19

 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
 

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1418994