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 Querying Tables

Posted by Karolis Strazdas
Karolis Strazdas
1,276 Points

SQL Error

"Select all movies from the year 2003."

SELECT * FROM movies WHERE year > 2003;

Syntax is correct, but it gives me an error.

1 Answer

Ryan Field
PLUS
Ryan Field
Courses Plus Student 21,242 Points
Ryan Field
Ryan Field
Courses Plus Student 21,242 Points

Hi, Karolis. If you want movies from the year 2003, you need to use =, not > in you database call.

Karolis Strazdas
Karolis Strazdas
1,276 Points

Yeah. I understood this question incorrectly.:D