Labels

Thursday, August 25, 2016

Logical processing order of SELECT statement

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