求一写法

Question

要从表中取出第3到第7条记录.在MySql中：select * from student limit 3, 7在Oracle中怎么写？我的id是用的guid.

Answer 1

select * from student
where rownum<=7
minus
select * from student
where rownum<=2;select * from
   (select s.*,rownum rn from student s)
where rn between 3 and 7;

Answer 2

select * from
(
select a.*,rownum rc
                from(
select *
                        from student                      )a
                  where rownum <= 7
         ) b          where rc >= 3