Reading Data from Databases with SQL, Limiting the Result Set

Question

I am having a hard time understanding the limit and offset parts of MYSQL. Could someone use this example "Get the 101st to 200th actor from the actors table. (No need to use any ordering)." and explain to me how this would work and the math behind it? Thanks!

Yosi Dahari · Accepted Answer · 2013-10-12 15:20:27Z

2

`SELECT * FROM table limit 100, 100` -- get 100 records from row 101 (101 - 200)

This will give you 50 records after 101:

`SELECT * FROM table limit 100, 50` -- get 50 records from row 101 (101 - 150)

For more details, you can see the syntax and usage for limit here.

edited Oct 12, 2013 at 15:20

answered Oct 12, 2013 at 14:40

Yosi Dahari

7,0395 gold badges26 silver badges48 bronze badges

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

1 Comment

Yosi Dahari Over a year ago

Limit A (default = 0), B (default = #rows in the result set) - means get B rows starting at row number A + 1

Ramppy Dumppy · Accepted Answer · 2013-10-12 14:14:16Z

0

 select actor
 from actorTable limit 100, 200

it will get all the actor starting from 101 up to 200 it will always add 1 to the min limit up to the max limit which is 200

answered Oct 12, 2013 at 14:14

Ramppy Dumppy

2,8477 gold badges30 silver badges38 bronze badges

Collectives™ on Stack Overflow

Reading Data from Databases with SQL, Limiting the Result Set

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related