what is the order of execution of where,having,group by in
select stement
Answer Posted / bhagyashri jain
First of all,
when Group by and having clauses are there , the Where
clause can't present there, so order of group by, having is
respectively
Group by
Having
Is This Answer Correct ? | 6 Yes | 20 No |
Post New Answer View All Answers
What are the tools available in market as an alternative to sql server reporting services?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
When would you use sql joins?
After removing a table from database, what other related objects have to be dropped explicitly?
What does it mean to manipulate data?
Is it safe to delete log files?
What are the database objects? : SQL Server Architecture
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is the use of RDBMS?
What are different types of statements that are supported by sql?
List few advantages of stored procedure.
How do I find my localdb version?
What is cross join in sql server joins?
Explain the truncate command?
What language is sql server written in?