When Can you be sure that a query will return only one row?
Answer Posted / shekhar
when u use column function without using group by clause. it will give only single value. PLz correct if i m wrong.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain about open switch business continuity software?
What is the role of data manager in the db2 database?
What is the role of schema in the db2 database?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How does cobol compile db2 program?
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.
What is page size 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 is sqlca?
How do I delete a table in database?
Outputs of explain are with matchcols = 0. What does this signify?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What happens in bind step in a db2 program?
What is the physical storage length of timestamp data type?
How to check table size in db2 sap?