When teaching SQL to college students and business professionals, I find that they pick up on the ๐๐๐๐๐ ๐๐ clause very quickly as its use is rather intuitive given their familiarity with Microsoft Excel. At SQL Short Reads, I demonstrate how to use the ORDER BY clause to sort data based on the following: โฝPre-existing attributes/columns โฝThe results of aggregate functions โฝAliases โฝNon-selected attributes I also showcase how to implement more heavily customized sorting that goes beyond the standard ascending and descending sort methods and discuss how NULLS are handled when sorting data. ๐๐ข๐ฉ: Sorting the output of a query can be a costly operation. In todayโs business intelligence environment, your queries will likely originate from a data visualization tool such as Tableau or Power BI. Avoid including an ORDER BY clause in these queries because it is likely you and the consumers of your reports will be using the tool to sort the data displayed dynamically. In the case of Tableau, an ORDER BY clause is not allowed when using the toolโs Custom SQL feature. You can learn more about the ORDER BY clause by visiting SQL Short Read's ORDER BY page. A link can be found in the comments section. ๐๐ซ๐๐๐ญ๐ข๐๐ ๐ฐ๐ก๐๐ญ ๐ฒ๐จ๐ฎ ๐ฅ๐๐๐ซ๐ง ๐ฎ๐ฌ๐ข๐ง๐ ๐๐๐ ๐๐ก๐จ๐ซ๐ญ ๐๐๐๐โ๐ฌ ๐ฉ๐ซ๐๐๐ญ๐ข๐๐ ๐ฉ๐ซ๐จ๐๐ฅ๐๐ฆ ๐ฌ๐๐๐ญ๐ข๐จ๐ง ๐๐จ๐ง๐ญ๐๐ข๐ง๐ข๐ง๐ ๐จ๐ฏ๐๐ซ 160 ๐ฉ๐ซ๐จ๐๐ฅ๐๐ฆ๐ฌ. ๐๐๐ ๐ญ๐ก๐ ๐๐จ๐ฆ๐ฆ๐๐ง๐ญ๐ฌ ๐ฌ๐๐๐ญ๐ข๐จ๐ง ๐๐จ๐ซ ๐ ๐ฅ๐ข๐ง๐ค. #SQL #SQLShortReads #DataAnalytics #DataEngineering
Gaurav Gupta
3w
Great insights on the ORDER BY clause! It's true that sorting data can often feel intuitive for those familiar with tools like Excel. I appreciate how you break down the various ways to sort data, including by attributes, aggregate functions, and aliases. The tip about avoiding ORDER BY in queries originating from data visualization tools like Tableau and Power BI is particularly usefulโsaves on processing time and allows for more dynamic data interaction within the tools. For anyone looking to deepen their understanding and practice their skills, definitely check out SQL Short Readโs practice problem section. It's an invaluable resource with over 160 problems to hone your SQL expertise. Thanks for sharing this!
Understanding the intricacies of SQL and its practical applications is necessary for both students and professionals in the data field. It's essential to delve deeper into these topics to enhance one's proficiency in SQL.
Digital Intelligence at Experian | Founder of SQLShortReads.com
4wโป ORDER BY - https://sqlshortreads.com/sql-fundamentals/the-big-six/order-by-clause/ โป For practice problems focused on the ORDER BY clause, see problem numbers 56-61 at https://sqlshortreads.com/sql-practice-problems/easy/