Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools

Posted by Joshua Moore
Joshua Moore
8,013 Points

limiting the result set, challenge 1

Question: Get the 101st to 200th actor from the actors table. (No need to use any ordering).

My answer: SELECT * FROM actors LIMIT 101, 99;

2 Answers

John W
John W
21,558 Points
John W
John W
21,558 Points

First number is the offset, consider the following: without offset (0), we start at 1; what offset do we use to start at 2? what about 3? what about 101?

Second number is the count, how many numbers are between 101 and 200 inclusive? (how many numbers are between 1 and 100 inclusive?)

Joshua Moore
Joshua Moore
8,013 Points

Got it. Thanks. Was kinda confusing to me

Ryan Boone
Ryan Boone
26,518 Points
Ryan Boone
Ryan Boone
26,518 Points

I'm entering: SELECT * FROM actors LIMIT 1, 100; and it's not saying it's correct. What am I doing wrong?