Mysql fetch data between two rows

Question

Newbie question: I want to get data between two rows, say, row number 5 and row number 10. How can I do that? There is no id or any integer column in the table and I cannot modify the table.

Answer 1

You can use limit

select * from `table` limit 4,5;