ORDER BY Clause in SQL: SQL 30 Day Challenge Day 9
Day 9 is about ordering our data (result set). You can order data in ascending order (like LastName), or descending order (like most recent purchase dates). This is beneficial when looking at the top and bottom of data to really explore the data (more on this later).
/*Sort the invoices table to get the
most recent purchase dates listed first */
/*Sort the invoices table by highest total
then the State in alphabetical order*/
-----------------------------------------------------------------
Download SQLite Studio Here: https://sqlitestudio.pl/
Download the Chinook Database: https://www.sqlitetutorial.net/sqlite...
Link to Topic List: https://docs.google.com/document/d/1f...
Link to Facebook Support Group: / 767988395118964
Link to my Data Etsy Shop (support me to keep making content): https://jellysgeekygoods.etsy.com
Buy me a coffee to show support: https://buymeacoffee.com/learningwith...
#sql #sqltutorial #sqlforbeginners
