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 Dealing with NULL

Wilson Bridgestone
Wilson Bridgestone
5,850 Points
Posted by Wilson Bridgestone
Wilson Bridgestone
5,850 Points

I see a problem with the actors database file. The actors names are not the same as in the workbench file.

I tried to answer a question using this query select * from actors limit 99 offset 100;

This statement works correctly in the workbench but when I use it to answer the question it returns an incorrect answer.

I also noticed the name adolf hitler as one of the actors name. I am sure that name is not supposed to be in the list.

Paulius Vitkus
Paulius Vitkus
24,230 Points
Paulius Vitkus
Paulius Vitkus
24,230 Points

The answer is:

SELECT * FROM actors LIMIT 100 OFFSET 100;

And I haven't seen Adolf Hitler in the list. Maybe Tree House team had updated it :)