sql for select intermediate rows

there are 10 rows in student tablei need to get 5 th and 6 th rows.
1)how can i get these rows using select query
2)is there any other way to get other than select query?

Use Rownum or equivalent

What database is this

MySql ?

i think we can't use rownum to get middle records?

This will display the first 10 results from the database.

This will show records 6, 7, 8, 9, and 10