What is the difference between Where and Having Clause
- 7 Answers
- 27529 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
Answer Posted / md amanullah
Where Clause:
1)WHERE clause can be used without GROUP BY clause.
2)WHERE clause select rows before grouping.
3)WHERE clause can not contain aggregate functions.
4)WHERE clause can operate individual row.
5)It is more fast.
Having Clause:
1)HAVING clause can not be used without GROUP BY clause.
2)HAVING clause select rows after grouping.
3)HAVING clause can contain aggregate functions.
4)HAVING clause can operate group of row.
5)It is much slow.
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is the use of dclgen in db2?
What is blu acceleration in db2?
What is the role of the data page in the db2 database?
What is the clustering index in the db2 database?
How to connect to db2 database from windows command line?
How do I copy a table in db2?
How do I add a column in db2?
Explain db2.
What is package in cobol db2?
What is explain in db2?
What is a db2 package?
What are the 2 sqlcodes that are returned?
what are bind concepts in db2 cobol?
What is the usage of open cursor command?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
