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

Опубликовано: 22 Март 2025
на канале: Michael Fudge

1,848

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-data...

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. • Learn Databases Walkthrough

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

Here's the entire playlist: • Applied Database Management with SQL