Execution of SQL Queries Order

Whenever SQL Server needs to perform a query execution additional following Transact-SQL statements are executed:

1) FROM

2) WHERE

3) GROUP BY

4) HAVING

5) SELECT

6) ORDER BY

7) LIMIT

We will be give more details about above conditional clauses in next blog…