Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29949 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
Detail about the hardware which is supported by SQL server?
How to find the list of fixed hard drive and free space on server?
what is datawarehouse?
What are the instances when triggers are appropriate?
How to concatenate two character strings together?
How to use “drop” keyword in sql server and give an example?
Which is faster statement or preparedstatement?
What are sparse columns?
Does index slows down insert statements?
How to use union to merge outputs from two queries together in ms sql server?
Explain the creation and execution of a user-defined function in the sql server?
Determine when to use stored procedure to complete sql server tasks?
What is the difference between index seek vs. Index scan?
What are the new features of sql server 2008 r2 reporting service?
What is the benefit of normalization?
