what is the order of execution of where,having,group by in
select stement
- 6 Answers
- 20490 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
What is the optimization being performed in oracle and SQL Server?
Difference between uniqe index and uniqe constraint?
Is sql different from sql server?
What is the difference between NOROW and LOCKROW?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How to create a view with data from multiple tables?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How sql server enhances scalability of the database system?
How to change the system date and time from SQL Plus Terminal ?
What is a self join in sql server?
What is the Main Difference between ACCESS and SQL SERVER?
How to apply cascading referential integrity in place of triggers?
What is 2nf normalization?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is the cartesian product of the table?
