What is the difference between Where and Having Clause
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 are the various data types available in db2?
What is the latest version of ibm db2?
What is database alias db2?
What's The Error Code For Unique Index Voilation?
What is with ur in db2?
What is a db2 schema?
What are concurrency issues?
How do I change the column size in db2?
What is a page in db2?
Mention the location where the output received from explain statement is stored.
What is a bind card?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What do you mean by between and in? Is between inclusive of specified range values?
What is the information associated with sysibm.syslinks table?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2