select first_name from ( select first_name ,rownum numfrom s_emp where rownum between 1 and 15) where num>=10 andnum<=15;s_emp 是表名first_name是要查询的字段。
select * from 表名 where rownum>10 and rownum<15
select * from 表名 where rownum>10 and rownum<=15