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.

If you want to talk about row numbers and rows between them, you have to specify how you order the rows. There is no natural ordering on rows in MySQL. — Martijn
– Martijn, Commented Apr 27, 2011 at 6:45
@martijn: The answer by Harry Joy satisfied my needs. However, I will read more about ordering in MySQL. Thank you. — Neeraj
– Neeraj, Commented Apr 27, 2011 at 8:02

Harry Joy · Accepted Answer · 2011-04-27 06:41:39Z

4

You can use limit

select * from `table` limit 4,5;

answered Apr 27, 2011 at 6:41

Harry Joy

59.8k30 gold badges166 silver badges211 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Neeraj Over a year ago

I am a first time user. Moreover, there is a certain time limit before which you cannot upvote/accept an answer.

Collectives™ on Stack Overflow

Mysql fetch data between two rows

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related