**Course Title:** SQL Mastery: From Fundamentals to Advanced Techniques **Section Title:** Data Retrieval with SQL: SELECT Queries **Topic:** Sorting results with ORDER BY Welcome to this topic in the SQL Mastery course, where you'll learn how to sort the results of your SQL queries using the ORDER BY clause. By the end of this topic, you'll understand how to ascend and descend columns, handle multiple columns, and deal with special cases like NULL values. **Why is sorting important in SQL?** Sorting is an essential feature of any data retrieval system. It allows you to present your data in a meaningful order, making it easier to analyze and understand. Imagine searching for a specific product on an e-commerce website and getting a list of results without any particular order. It would be hard to find what you're looking for, right? That's where ORDER BY comes in. **The ORDER BY syntax** The syntax of the ORDER BY clause is as follows: ``` SELECT column1, column2, ... FROM table_name ORDER BY column_name ASC/DESC; ``` Here's what each part does: * `SELECT`: Selects the columns you want to retrieve. * `FROM`: Specifies the table(s) you want to retrieve data from. * `ORDER BY`: Sorts the result set in ascending or descending order. * `column_name`: Specifies the column you want to sort by. * `ASC/DESC`: Specifies the sorting order (ascending or descending). **Ascending vs. Descending Order** By default, SQL sorts columns in ascending order (from smallest to largest). If you want to sort in descending order (from largest to smallest), you need to specify the `DESC` keyword after the column name. Example: ``` SELECT id, name, price FROM products ORDER BY price DESC; ``` This query will return a list of products sorted by price in descending order. **Sorting Multiple Columns** You can sort by multiple columns by listing them separated by commas. Example: ``` SELECT id, name, price FROM products ORDER BY price DESC, name ASC; ``` In this example, the query will first sort by price in descending order, and then by name in ascending order for products with the same price. **Handling NULL Values** When sorting columns that may contain NULL values, you need to be aware of the following: * By default, NULL values are sorted first when sorting in ascending order. * NULL values are sorted last when sorting in descending order. If you want to sort NULL values as the last result, you can use the `NULLS LAST` clause: ``` SELECT id, name, price FROM products ORDER BY price DESC NULLS LAST; ``` Alternatively, you can use the `CASE` statement to replace NULL values with a specific value, and then sort accordingly: ``` SELECT id, name, price FROM products ORDER BY CASE WHEN price IS NULL THEN 0 ELSE price END DESC; ``` **Practical Takeaways** * Use the ORDER BY clause to sort the results of your SQL queries. * Specify the column(s) you want to sort by and the sorting order (ascending or descending). * Use the `ASC` and `DESC` keywords to control the sorting order. * Sort by multiple columns by listing them separated by commas. * Be aware of how NULL values are handled when sorting columns. **Try it Yourself!** Try sorting the data in your own database or using a publicly available dataset like [IMDB](https://www.imdb.com/interfaces/) (Internet Movie Database). Create a query that sorts a column in ascending and descending order, and experiment with sorting by multiple columns. **Resource Links** * [SQL Fiddle](https://sqlfiddle.com/) - A platform to test and share your SQL queries. * [W3Schools SQL Tutorial](https://www.w3schools.com/sql/) - A comprehensive SQL tutorial with examples and exercises. **Leave a Comment or Ask for Help!** If you have any questions or need help with a specific scenario, feel free to leave a comment below. This is the perfect opportunity to get feedback and guidance on your SQL skills. **Up Next** In the next topic, we'll cover how to limit the result set with `LIMIT` and `OFFSET`. Stay tuned!

SELECT column1, column2, ...
FROM table_name
ORDER BY column_name ASC/DESC;

SELECT id, name, price
FROM products
ORDER BY price DESC;

SELECT id, name, price
FROM products
ORDER BY price DESC, name ASC;

SELECT id, name, price
FROM products
ORDER BY price DESC NULLS LAST;

SELECT id, name, price
FROM products
ORDER BY CASE WHEN price IS NULL THEN 0 ELSE price END DESC;