What is the difference between Where and Having Clause
- 7 Answers
- 27525 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 the picture clause of null indicator variable?
What is a buffer in memory?
What is bind plan?
What do you mean by commit and rollback?
What is page size in db2?
B37 abend during spufi?
Is ibm db2 free?
What is host variable?
How can you do the explain of a dynamic sql statement?
What is access path in db2?
What is concurrency?
Name the lockable units in DB2?
What is database alias db2?
What do you mean by cursor?
What does db2 stand for?
