Logical processing order of SELECT statement in SQL Server
When SQL query is executing on SQL server ,it has a order. This order call as Logical Processing Order.So let's logical processing order of SELECT statement.
1. FROM
2. ON
3. OUTER
4. WHERE
5 GROUP BY
6 CUBE or ROLLUP
7 HAVING
8 SELECT
9 DISTINCT
10 ORDER BY
11 TOP
No comments:
Post a Comment