What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26984 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
How to perform key word search in tables?
How to find Duplicate Records In table?
How do I port a number to sql server?
Do you know what is fill factor and pad index?
Do you know what is similarity and difference between truncate and delete in sql?
How much is a sql server license?
What is DCL?
What is service broker?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is sqlcmd?
Explain external key management in sql server 2008
Define compound operators?
What is nested transaction?
What is SubQuery in SQL Server 2008
What are the advantages to use stored procedures?
