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

Databases

Posted by Mishu Jahur
Mishu Jahur
5,238 Points

I'm stuck on an exercise regarding the ORDER key word and LIMIT keyword, but the exercise is telling me to use WHERE

I'm stuck on an exercise on SQL which asks: "We're using the library database again. There's a books table. There's a title, author, genre and first_published column. Write a query to obtain the first 5 books in the Fantasy genre ordered by the year released. Oldest first. Select all columns."

However I'm prompted to use the WHERE keyword I don't see how or why I would use it

1 Answer

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,970 Points

in the Fantasy genre = use a WHERE clause

SELECT * FROM T1 WHERE condition ORDER BY C1 LIMIT 5

Mishu Jahur
Mishu Jahur
5,238 Points

Thanks, sorry I just realised I hadn't read it properly.