What is the difference between Where and Having Clause
Answer Posted / badal
both define condition
where for individiual records
group by for group of records
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
How is deadlock resolved?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is precompiler in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to take backup of table in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is buffer pool and list some of them?
When the like statement is used?
What is the information associated with sysibm.syslinks table?
How to find primary key of a table in db2?
What is cursor in dbms?
define clustering index.
What is release/acquire in bind?
Why do we use cursor?
What is cursor with hold option in db2?