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

Ruby

Posted by Peaches Stubbs
Peaches Stubbs
21,320 Points

Problem with a database challenge ?

I've tried to answer this a few times. The question is : Get the 101st to 200th actor from the actors table. (No need to use any ordering).

I tried: SELECT * FROM actors LIMIT 100 OFFSET 199;

also: SELECT * FROM actors LIMIT 100 OFFSET 200;

and: SELECT * FROM actors LIMIT 100. 199;

I also tried a few other ways but I keep being told to check the numbers. May somebody help me with this please?

1 Answer

Peaches Stubbs
Peaches Stubbs
21,320 Points

Okay I figured this out and no I won't spill the beans. What I will say is that if anybody else does come across this issue, remember that you are tryimg to display a certain amount of characters. There in lyes your answer.