what is the difference between where clause and having clause
- 2 Answers
- 7792 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / selvam a
HAVING clause can only compare a built in function but WHERE
clause can compare column name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happens in bind step in a db2 program?
How do I add a column in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is runstats db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Explain about rct.
What is the information associated with sysibm.syslinks table?
How do you concatenate the firstname and lastname from emp table to give a complete name?
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.
Can we insert update delete in view?
What is cascading rollback?
Mention some fields that are a part of sqlca.
List out the buffer pools in db2
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 ?
What db2 400?
