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
What are the differences between user defined functions and stored procedures?
What are the advantages of sql stored procedure?
Explain timestamp datatype?
Does partitioning improve performance?
How to achieve Paging of records in SQL SERVER?
How would you go about developing a ssrs report?
What are types of storage modes? : sql server analysis services, ssas
Where the sql logs gets stored? : sql server database administration
What is 5nf in normalization form?
Explain something about security and SQL Azure?
How to see the event list of an existing trigger using sys.trigger_events?
In what version of sql server were synonyms released?
Tell me what do we need queues in sql service broker?
What are differences in between sql server 2012 and sql server 2016?
In how many ways you can invoke ssrs reports?