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:
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