Oracle 分页查询:
查询从21到40的数据
select * from (
select a.*,rownum b from (
select * from biao
) where rownum <=40
) where b >20
MySql 分页查询 :
查询从21到40的数据
select * from biao where tiaojian limit 20,20
infoxmix 分页查询:
10.0版本之前: select * from biao where tiaojian limit 20,20
10.0版本之后: select skip 20 first 20 * from biao (跳过前20条取20条数据)
DB2 分页查询:
与oracle分页一样
select a.*,rownum b from (
select * from biao
) where rownum <=40
) where b >20