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


Please Help Members By Posting Answers For Below Questions

What are the differences between user defined functions and stored procedures?

529


What are the advantages of sql stored procedure?

527


Explain timestamp datatype?

548


Does partitioning improve performance?

477


How to achieve Paging of records in SQL SERVER?

589






How would you go about developing a ssrs report?

110


What are types of storage modes? : sql server analysis services, ssas

574


Where the sql logs gets stored? : sql server database administration

520


What is 5nf in normalization form?

561


Explain something about security and SQL Azure?

88


How to see the event list of an existing trigger using sys.trigger_events?

564


In what version of sql server were synonyms released?

501


Tell me what do we need queues in sql service broker?

511


What are differences in between sql server 2012 and sql server 2016?

562


In how many ways you can invoke ssrs reports?

99