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 Database Foundations Reading Data from Databases with SQL Limiting the Result Set

I'm putting the following answer "SELECT * FROM actors LIMIT 1. 100;" and I'm getting an error message. Help!

The question is asking for me to get the 101st to 200th actor from the actors category.

2 Answers

Serge Honderdos
Serge Honderdos
8,918 Points

You are using a dot (.) instead of a comma (,) in your statement. Try this: SELECT * FROM actors LIMIT 1, 100;

It's still not working for some reason. Could there potentially be a bug with that test?

Serge Honderdos
Serge Honderdos
8,918 Points

In the code you are selecting number 1 to 100 the first argument is the offset and the second argument the amount.