Today in this blog I will tell you guys about the logical query processing order in SQL Server. SQL Server process the query in a certain order which is known as Logical query processing order.
We generally write the query in this order:
4. GROUP BY
6. ORDER BY
But SQL Server doesn’t process the query in same order. It will get executed in this order:
5. GROUP BY
6. CUBE | ROLLUP
10. ORDER BY
Hope you guys like this post.