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条记录
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条记录
select top ? * from Cat order by newid() select top 100 * from Cat order by newid() 从Cat表中随机取出100条记录