Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30480 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
Answer Posted / narendra
Both are used to filter the rows but
where is used to filter the rows on single row functions and
having is used to filter the rows on group functions or aggregate functions.
one more thing i would like to mention is
having can be used without group by
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What is meant by union and union all?
What does db2 blu stand for?
What is precompiler in db2?
What is a bind in db2?
What is the purpose of rollback and commit?
Is db2 relational database?
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.
Is ibm db2 open source?
How do I add a column to an existing table in db2?
Discuss about db2 bind?
What is universal database?
How do you select a row using indexes in db2?
How is deadlock resolved?
How to create backup table in db2?
What is isolation level in db2?
