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
Explain the rules for designing files and file groups in sql server?
Explain the different types of joins?
What are different type of Collation Sensitivity?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What are trace files?
What is the fillfactor concept in indexes?
How to select some specific columns from a table in a query in ms sql server?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
How do you identify a foreign key?
Explain the functionalities that views support?
What is multi-statement table-value user-defined function?
What is the difference between locking and multi-versioning?
Explain the truncate command? : SQL Server Architecture
What are a scheduled jobs or what is a scheduled tasks?
What is temporal data type?