Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30455 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
How to compare data between two tables in db2?
What is table space in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is data manager?
Mention some fields that are a part of sqlca.
What is null indicator in db2?
What do you mean by rollback?
What is buffer pool and list some of them?
Discuss about db2 bind?
What does reorg do in db2?
Which component is responsible for db2 startup and shutdown?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is ibm db2 connect?
What is database reorganization?
What is the use of predicate?
