所有操作的表为emp表 Oracle select * from emp where rownum < ?; select * from emp where rownum < 100; //选择前100条记录 select * from (select emp.* , rownum as num from emp where rownum < ?) where num > ?; select * from (select emp.* ,rownum as num from emp where rownum < 8) where num >= 2 ; //从emp表中取出记录号为 2至7的6条记录 MySQL select * from emp limit ?,?; select * from emp limit 10, 100; //从emp 表中第10条开始取出100条记录 select * from emp limit ?; select * from emp limit 100; //从0条开始 取出100条记录 select * from emp order by rand() limit ?; select * from emp order by rand() limit 100; //随机取100条记录