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
What is sqlca’s maximum length?
How to find the maximum value in a column in the db2 database?
How do I add a column in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is explain plan in db2?
What is runstats and reorg in db2?
What is multi row fetch in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is drop table?
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 the syntax for seeing the columns and data types of a table in the db2 database?
What are the bind parameters ibm db2?
What is the difference between oracle and db2?
Why do we need reorg in db2?
What is dpf in db2?