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 |
What are the steps to insert a table?
What is exclusive locks?
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>
What command do we use to rename a db, a table and a column?
What is the disadvantages of index?
What is etl - extraction, transformation, and loading?
Explain comment on transactions?
Difference between Triggers and Stored Procedure
23 Answers Claimat, HCL, Protech, Silgate,
Explain about system stored procedure?
How to find the date and time of last updated table?
How to find the date and time of last updated table?
What is a natural primary key?