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

Tableau interview questions and answers for experienced professionals

  Tableau Interview Questions and Answers for experienced professional 1. What is TABLEAU? Tableau  is the powerful and fastest visualizing ...