What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 30204 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
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
What are different types of constraints?
How efficient you are in oracle and SQL server?
What is sql server query analyzer?
What are the properties of the transaction?
What is clustered index
Equi join and non equi join is possible with sql server?
Explain “row_number()” in sql server with an example?
What is a coalesce function?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are the source of constraints?
Can sql servers link to other servers like oracle?
How to connect php with different port numbers?
Explain system functions or built-in functions? What are different types of system functions?
What is the difference between for xml raw and for xml auto?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
