From Excel to SQL - Sorting Data (ORDER BY)
Sorting data is super useful for making sure that your output is in the order that you want, particularly for SQL which has a habit of throwing your rows into any kind of order otherwise!
The dbfiddle website can be accessed for free and without an account at:
https://dbfiddle.uk/
Make sure to use the SQL Server dialect and the AdventureWorks sample database to be able to follow along with these examples!
---------------------------------------------------
This is part of the From Excel to SQL playlist, available at:
• From Excel to SQL
Check out the previous video at:
• From Excel to SQL - Filtering Data (WHERE)
...and the next video at:
• From Excel to SQL - Comments (-- and /**/)
---------------------------------------------------
CHAPTERS
00:00 Intro
00:28 Recap
01:06 Sorting in Excel
02:45 Sorting in SQL
03:26 Sorting in descending order
03:58 Sorting by multiple columns
05:41 Using aliases in ORDER BY
07:15 Wrap up