what is the order of execution of where,having,group by in
select stement
Answer Posted / shivaraj
Execution-1- WHERE
Execution-2- GROUP BY
Execution-3- HAVING
| Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
How do you create type- insensitive operator?
What is an execution plan? How would you view the execution plan?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Give me any three differences between Truncate and Delete.
Write an SQL query to obtain the 2nd highest salary.
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What program is used to store the data source file?
What are logical/boolean operations in ms sql server?
What is the Control Flow in SSIS
What happens when transaction log is full?
How to create a local temporary stored procedure?
Explain external key management in sql server 2008
Explain primary key?
How to start and end transact-sql statements?
What is a transaction and why is it important?