Published On Jul 3, 2013
SQL Server processes code in a sequence which is known as the Logical Query Processing order. In a typical query, the logical processing order is : FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY. Each step produces a virtual table that is used in the next step. The logical Query Processing order is different from the order in which the code is written ("keyed-in order") which would be SELECT, FROM, WHERE, GROUP BY, HAVING ,ORDER BY. Understanding the Logical Query Processing order is important as it can impact whether a query works or generates errors.
I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...