What is the difference between Where and Having Clause
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
Is it possible using max on a char column?
What is bind and rebind in db2?
What is a collection in db2?
How can we retrieve the total number of records in RPG & CLLE?
What is package in cobol db2?
What is cloudant database?
How does cobol compile db2 program?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How do you select a row using indexes in db2?
what is the responsibility of the construction superintendent
Where do you specify them?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What do you mean by commit and rollback?
What r the comman abends in db2, jcl and cobol???????