Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30221 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 difference between db2 and oracle?
What is ibm db2 used for?
Define db2.
Explain about dbrm.
What are bind parameters in db2?
What is the reason behind not using select * in embedded sql programs?
what is db2 restart?
What is clone table?
What is null indicator in db2?
Who uses db2?
What is rct?
What is the picture clause of null indicator variable?
What is blu acceleration in db2?
What is the difference between nvl and coalesce?
Comment whether the cursor is closed during commit or not.
