9/17/2018

Select query order of execution in SQL Server

In Many interview, this questions generally asked by the interviewer that what is the correct order of Select query for execution by SQL Server engine.

Below I have mentioned the correct order of SQL server query execution which SQL Server used to execute:


1. FROM and Joins
2. Where
3. Group By
4. Having
5. Select
6. Distinct
7. Top
7. Order By

No comments:

Post a Comment

Power BI Interview Questions and Answers

Power BI Interview Questions For Freshers The rising need for organizations to make decisions based on data has increased the demand for c...