sql for select intermediate rows

[Samanthi perera]

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?

[Deepak Bala]

Use Rownum or equivalent

What database is this

[Samanthi perera]

MySql ?

[Samanthi perera]

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

[harilal ithikkat]

SELECT * FROM `your_table` LIMIT 0, 10  

This will display the first 10 results from the database.

SELECT * FROM `your_table` LIMIT 5, 5 

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