what is the order of execution of where,having,group by in
select stement
- 6 Answers
- 21432 Views
- IBM, Tanla Solutions, I also Faced
- E-Mail Answers
Answer Posted / bobby
The order of syntax for SELECT statement is
Select Top| Distinct
From Join
On
Where
Group By
Having
Oder By
But the order of execution of SELECT statement is
1.From
2.On
3.Join
4.Where
5.Group By
6.Having
7.Distinct
8.Select
9.Order By
10.Top
| Is This Answer Correct ? | 30 Yes | 2 No |
Post New Answer View All Answers
How to create an index on a view?
What is repeatable read?
What is 5nf in normalization form?
Can binary strings be used in arithmetical operations?
What is the difference between char, varchar and nvarchar?
What is a dbms wizard?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Is mysql better than sql server?
How you can get a list of all the table constraints in a database? : Sql server administration
You want to implement the one-to-many relationship while designing tables. How would you do it?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is the sql case statement used for?
What are the advantages dts has over bcp?
What is index in an assignment?
How to test subquery results with the exists operator?
