数据库分页

DB2分页
SELECT * FROM (
?select rownumber() over(order by tkjl.txsj DESC) as rownum,tkjl.* FROM XXXXX tkjl
)where rownum < 100

?

SELECT * FROM (
?select rownumber() over(order by tkjl.txsj DESC) as rownum,tkjl.* FROM XXXX tkjl
)where rownum between 1 and 20

MYSQL分页
select * from Userinfo limit 1,20

?

Oracle 分页
select * from (
?select rownum,k.* from XXXXX k where kadm like ‘32%‘
) where rownum between 1 and 20

?

--每次取得10条数据
select * from (
?select rownum,k.* from XXXXX?? k where kadm like ‘32%‘
) where rownum <11

数据库分页

原文：http://gaojingsong.iteye.com/blog/2266950