Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29170 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 create a scrollable cursor with the scroll option? : Sql server database administration
What are the requirements to use odbc connections in php scripts?
What are the advantages of the mirroring?
How do I start and stop sql server?
What does nvl stand for?
How to sort the query output with order by clauses in ms sql server?
Which are the third-party tools used in sql server and why would you use them?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
List out what other servers you can use with ssrs?
What is sharding?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Is a primary key unique?
In case you have filters in your report, when filters will be applied in cached report instance?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Can a function call a stored procedure in sql server?
