oracle
select * from (select * from (select s.*, rownum rn from student s)
where rn<=5) where rn>0
mysql
select * from table_name where 1 =1 limit (start, end)
select * from (select * from (select s.*, rownum rn from student s)
where rn<=5) where rn>0
select * from table_name where 1 =1 limit (start, end)