oracle 페이지나누기 , mysql 페이지나누기

/* oracle */
SELECT *
FROM(
select rownum as rn,A.*
from(
select rownum,bno,writer,subject,regdate,username
from inquireboard b,user2 u 
where b.writer = u.userid
order by bno
)A
)
where rn between 1 and 5;

/* mysql || mariaDB */
select * from table limit 0 , 5;