What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
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 is bit data type? What's the information that can be stored inside a bit column?
How to drop an existing table with "drop table" statements in ms sql server?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What are locks in sql?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Explain the phases a transaction has to undergo?
How can you check the version of sql server?
how would you improve etl (extract, transform, load) throughput?
What is read committed?
What is the difference between having clause and where clause in sql server?
If we delete pack Spec what will be the status of pack Body ?
State a few properties of relational databases?
How can you insert values in multiple rows using one Insert statement?
How to create a stored procedure with a statement block in ms sql server?
How can you fetch alternate records from a table?