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


Please Help Members By Posting Answers For Below Questions

What is sqlca’s maximum length?

920


How to find the maximum value in a column in the db2 database?

850


How do I add a column in db2?

810


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

816


What is explain plan in db2?

797


What is runstats and reorg in db2?

1036


What is multi row fetch in db2?

801


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2003


What is drop table?

798


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 .....

2136


What is the syntax for seeing the columns and data types of a table in the db2 database?

842


What are the bind parameters ibm db2?

827


What is the difference between oracle and db2?

819


Why do we need reorg in db2?

757


What is dpf in db2?

883