what is the order of execution of where,having,group by in
select stement
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shivaraj
Execution-1- WHERE
Execution-2- GROUP BY
Execution-3- HAVING
Is This Answer Correct ? | 26 Yes | 2 No |
Answer / lakshmi
from clause
where
group by
having
distinct
order by
select
Is This Answer Correct ? | 2 Yes | 5 No |
Answer / bhagyashri jain
First of all,
when Group by and having clauses are there , the Where
clause can't present there, so order of group by, having is
respectively
Group by
Having
Is This Answer Correct ? | 6 Yes | 20 No |
How to modify existing triggers using "alter trigger"?
When would you use it?
wat is tuff file in log shipping, wt is d use of tht file?
Can group by and orderby be used together?
how to dispaly a particular row details from a given table
How to get the count of distinct records. Please give me the query?
How many database files are there in sql server 2000?what are they?
mention different types of relationships in the dbms?
What is create statement?
How to resolve the orphan use problem? : sql server security
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)
10 Answers Cognizant, Infosys,
Where to find ntwdblib.dll version 2000.80.194.0?