SQL Server -SQL Select Statement Binding Order

Hi,

The article about how SQL Server will process SELECT statement during execution or running in Management Studio ( SSMS ).

Here, I have to update and add some more add-ins for SELECT statement execution. Please find the below order of how SQL Server will execute:

1.FROM
2.ON
3.JOIN
4.WHERE
5.GROUP BY
6.WITH CUBE or WITH ROLLUP (deprecated)
7.HAVING
8.SELECT
9.DISTINCT
10.ORDER BY
11.TOP

Hope, this helps to understand about SELECT statement binding order.