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
Emmet Lowry
10,196 PointsNEED help with challenge 2 of the limiting result task
says i dont have the earliest science fiction book even though I do have that. any help with challange would be great. https://teamtreehouse.com/library/reporting-with-sql/ordering-limiting-and-paging-results/limiting-results
3 Answers
Emmet Lowry
10,196 Pointsthx for the help i had that answer not sure why it didnt pass might have been my browser.
ALBERT QERIMI
49,872 Pointsit is slightly different from what it says Jenifer First of all is asking for genre to be Science Fiction and then is asking just fre earliest book in the list so LIMIT mustbe 1
SELECT * FROM books WHERE genre="Science Fiction" ORDER BY first_published ASC LIMIT 1;
For any further question please ask again Thanks. i am not good in writing english sorry
Jennifer Nordell
Treehouse TeacherALBERT QERIMI Ah ha! You're right. I was looking at step 1 not step 2. I misread the question. I'll be removing my answer 
BRYANT GOLD
5,475 PointsUse the following query modifying the SARG or column names of need be
Select * From books Where genre = 'Fantasy' Order by first_published Limit 5;