Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30721 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 a storage group (stogroup)?
What is the default page size of buffer pools?
List some fields from sqlca?
What is db2 plan table?
How and when does the db2 enforces the unique key?
Comment whether the cursor is closed during commit or not.
What is ibm db2 connect?
What are union and union all?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the syntax for FETCH in DB2 ?
Is ibm db2 open source?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is db2 catalog database?
What do you mean by cursor?
Why cursor is used in db2?
