What is the difference between Where and Having Clause
- 7 Answers
- 28612 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
Answer Posted / njadav
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 ? | 2 Yes | 1 No |
Post New Answer View All Answers
what is a corelated subquerry?
What is db2 stogroup?
Explain how can you do the explain of a dynamic sql statement?
How can you do the explain of a dynamic sql statement?
Are views updateable?
Define declaration generator (dclgen).
When the like statement is used?
What does reorg do in db2?
What are the prerogatives?
What is commit in db2?
What is the use of reorg in db2?
What is the advantage in De-normalizing tables in DB2?
Mention the different locking levels that are available in db2.
What is the physical storage length of time data type?
Define db2.
