Fetch Record from X row to Y row

hi.....

How to fetch the record in tables from X row to Y row without using limit in MySQL.?


Regards,
S.Ashokkumar
India.

There are different solutions for this..
but it depends on how the table is structured.

the obvious solution would be : Use the auto_increment colunm if the table has one.

more info on your table.