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!
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
Robert Cate7,911 Points
Limiting the Result Set Code Challenge 1 of 2 ( DATA BASE FOUNDATIONS)
Starting to get a bit frustrated and just want to double check if there is currently a problem....(or maybe I'm completely missing something here :))
Here is the challenge : <strong>Get the 101st to 200th actor from the actors table. (No need to use any ordering).</strong>
Here is what I put in: <strong>SELECT * FROM actors LIMIT 99, OFFSET 100;</strong>
I've also tried... <strong>SELECT * FROM actors LIMIT 100, 99;</strong>
But I'm getting back an incorrect answer...
Would love some help here!
Thanks in advance