(转)常用数据库分页代码

dzgwt2004

MySQL
select * from Cat limit ?,?select * from Cat limit 20000,100从Cat表中第20000条开始取出100条记录，即记录号为20000到20099的记录select * from Cat limit ?select * from Cat limit 100从Cat表中取出记录号为1到100的记录select * from Cat order by rand() limit ?select * from Cat order by rand() limit 100从Cat表中随机取出100条记录

Oracle
select * from (select *, rownum rownum_ from Cat where rownum <= ?) where rownum_ > ?select * from (select *, rownum rownum_ from Cat where rownum <= 20099) where rownum_ > 19999从Cat表中第20000条开始取出100条记录，即记录号为20000到20099的记录select * from Cat where rownum <= ?select * from Cat where rownum <= 100从Cat表中取出记录号为1到100的记录select * from (select * from Cat order by dbms_random.value) where rownum < ?select * from (select * from Cat order by dbms_random.value) where rownum < 100从Cat表中随机取出100条记录
HSQLDB
select * from Cat limit ? ?select * from Cat limit 20000 100从Cat表中第20000条开始取出100条记录，即记录号为20000到20099的记录select * from Cat top ?select * from Cat top 100从Cat表中取出记录号为1到100的记录SQL Serverselect top ? * from Cat order by newid()select top 100 * from Cat order by newid()从Cat表中随机取出100条记录