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
Is foreign key a primary key?
Explain logical operators in sql server?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Can binary strings be converted into numeric or float data types?
How to create a scrollable cursor with the scroll option?
How to encrypt Strored Procedure in SQL SERVER?
How can windows applications connect to sql servers via odbc?
What is truncate table?
Explain features of analysis services?
List some of the rules that apply to creating and using a ‘view’
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is code near application topology?
how many no of arguments can be passed in procedures and functions
Write a query to find 5th highest amount paid from the customer table.
Explain what are the database objects? : SQL Server Architecture