Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29685 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / menagadev
The HAVING clause sets conditions on the GROUP BY clause
similar to the way WHERE interacts with SELECT. The WHERE
search condition is applied before the grouping operation
occurs; the HAVING search condition is applied after the
grouping operation occurs. The HAVING syntax is exactly
like the WHERE syntax, except HAVING can contain aggregate
functions.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the differences between web role and worker role?
What happens if null values are involved in string operations?
What are different types of statement?
What is inline variable assignment?
What is difference between rownum and row_number?
How can we remove orphan records from a table?
How column data types are determined in a view?
Why would you call update statistics?
Mention the different authentication modes in sql server.
what kind of lan types do you know? : Sql server database administration
What is the exact numeric data type in sql?
What are sql servers used for?
Can I work with several databases simultaneously? : sql server management studio
What is a partition function in sql server?
What is use of except clause? How it differs from not in clause?
