what is the order of execution of where,having,group by in
select stement
- 6 Answers
- 20403 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
Explain Normalization and DE normalization
Can sql servers link to other servers like oracle?
How can you insert values in multiple rows using one Insert statement?
How to delete duplicate rows from table except one?
How to concatenate two binary strings together?
How can you insert null values in a column while inserting the data?
Explain the different types of joins?
What is default constraint?
Explain mixed authentication mode of sql server?
what is unique and xaml nonclustered index
What is a schema in ms sql server 2005?
how many clustered indexes can be created on a table? : Sql server database administration
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What are cursors and when they are useful?
Explain cross join or cartesian product in sql?
