what is the order of execution of where,having,group by in
select stement
Answer Posted / lakshmi
from clause
where
group by
having
distinct
order by
select
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Do you know what are the differences between lost updates and uncommitted dependencies?
What is replication and database mirroring?
What is cursors?
Explain how you can deploy an SSRS report?
What is the New in SQL server 2008?
Which tools are available to manage SQL Azure databases and servers?
Explain the working of sql privileges?
Do comments need to go in a special place in sql server 2005?
What is table level trigger?
How you can change the database name in SQL SERVER?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What are the steps to follow to configure SQL*Net?
Detail about the hardware which is supported by SQL server?