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
Ian Watkins
1,036 PointsStuck on challenge in Order By for Database
In the last challenge question for order by it says to order movies by year in ascending and title alphabetical. I can usually get it to do the year in order by the titles are not in alphabetical.
How do I tell sql to do both?
Thanks
1 Answer
Travis Favaron
13,038 PointsHi Ian,
You can achieve being able to order by both using a similar method to how you would select from two different columns.
James Barnett
39,199 PointsJames Barnett
39,199 PointsTravis Favaron - Remember our goal here on the forum is give help not answers, next time try giving an explanation and/or a hint instead.
Need more explanation on the distinction check this out.
Travis Favaron
13,038 PointsTravis Favaron
13,038 PointsChanged my answer to more accurately reflect the goals of the forum.