Master the SQL SELECT statement part 04: TOP, DISTINCT, ORDER BY

Description:
This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!

This video covers the ORDER BY clause in addition to the TOP and DISTINCT keywords, specifically
- Sort query output in ascending or descending order using ORDER BY
- Including multiple columns in ORDER BY
- Accessing column aliases in ORDER BY
- Using TOP to limit row output.
- Combining TOP with ORDER BY to affect output
- Using DISTINCT to remove duplicate rows from query output

The SQL code is available here: https://github.com/mafudge/learn-databases/tree/master/youtube

If you need to setup your own database environment, check out learn-databases! The easy way to get going and follow along with these videos. https://youtu.be/CxCUrQ6knRo

This video is part of the textbook Applied Database Management https://applieddb.com

Here's the entire playlist: https://www.youtube.com/playlist?list=PLyRiRUsTyUXghCQTvsCeMjOCVjIIPsopR