SQL Tutorial - Logical Query Processing
This video demonstrates the differences between how we write a query in Microsoft SQL Server and how the query is processed by the database engine. It is very important to understand the logical query processing order to understand how write queries correctly and also when analysing queries from a performance perspective.
T-SQL Querying
https://www.amazon.com/gp/product/073...
T-SQL Fundamentals
https://www.amazon.com/gp/product/150...
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
https://www.amazon.com/gp/product/073...
Logical Query Processing Order:
1. FROM
2. WHERE
3. GROUP BY
4. HAVING
5. SELECT
6. ORDER BY
