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: - https://www.youtube.com/playlist?list=PLEiRgvTilK5rhnVPQ_Tj3Q-CI0rGn_uiD Check out the previous video at: - https://youtu.be/g_5OxUYPx7E ...and the next video at: - https://youtu.be/H6SfeXFWWmg --------------------------------------------------- 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