What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / ravindran
1.WHERE clause can be used with SELECT,INSERT and UPADATE statements,where as HAVING clause can only be used with the SELECT statements.
2.WHERE filter after rows before aggregation(GROUPING),
where as,HAVING filters groups,after the aggregations are performed.
3.Aggregate functions cannot be used in the WHERE clause,unless it is in a sub query containing in a HAVING clause,where as,aggregate functions can be used in having clause.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What are different types of subquery?
Is it possible to have clustered index on separate drive from original table location?
Explain where clause?
Explain iaas, paas and saas?
Explain cdc and sql injection?
what is datawarehouse?
How except clause is differs from not in clause?
Do you know what are the differences between lost updates and uncommitted dependencies?
What are the properties of primary key?
Explain log shipping and mention its advantages.
What is the server name in sql server?
What is multilevel indexing?
How to find the second highest salary of an employee?
What is RMS migrations?