what is the order of execution of where,having,group by in
select stement

Answer Posted / sri

1. WHERE
2. GROUP BY
3. HAVING

Is This Answer Correct ?    39 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum length of an alert name?

610


What is a partition key?

526


What is sql language?

555


can we have a nested transaction? : Sql server database administration

513


What is an index in a database?

547






What is precedence constraint?

550


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

491


How to drop existing indexes in ms sql server?

598


What is a view in sql?

586


Explain what is log shipping?

587


What are basics of policy management?

618


What do you understand by intent locks?

581


What is default constraint in ms sql server?

540


Can a database be shrunk to 0 bytes, if not, why?

648


what types of replication are supported in sql server? : Sql server database administration

473