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
How to sort query output in descending order in ms sql server?
What is use of except clause? How it differs from not in clause?
What do you mean by a Composite primary key?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Explain indexed views and partitioned view with their syntax.
How to drop existing views from a database in ms sql server?
How to create new tables with "select ... Into" statements in ms sql server?
What do you understand by mirroring and mention the advantages of the mirroring?
What is a partition function in sql server?
What is user defined stored procedures?
What are sparse columns?
What are the types of user defined functions in sql server?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
How do I perform an unattended install of sql server 2000?
What is database dimension? : sql server analysis services, ssas