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

General Discussion

Robert Cate
Robert Cate
7,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

1 Answer

Robert Cate
Robert Cate
7,911 Points

Figured it out, it was 100, instead of 99,