各种数据库的分页

1. oracle                
2. 1.  SELECT * FROM 
      (
      SELECT A.*, ROWNUM RN 
      FROM (SELECT * FROM TABLE_NAME) A 
      WHERE ROWNUM <= 40
      )
      WHERE RN >= 21
3. db2
4. 1. 1.    SELECT    * from (SELECT    字段1,字段2,字段3,字段4,字段5,
      2. 1. rownumber() over(order by 排序字段 asc )
         2. as rowid  from 表名 )as a
         3.  where a.rowid >= startPage AND     a.rowid <endPage
5. mysql
6. 1.              SELECT    * FROM tablename
   2.                WHERE id < 9500 ORDER BY id DESC LIMIT 40,20;