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 difference between rollback and commit?

616


Explain how can you do the explain of a dynamic sql statement?

649


What is dbrm? When it will be created?

594


What is the syntax for FETCH in DB2 ?

671


How to test SQL -911 error while developing COB-DB2 program

6708






What is a db2 table?

595


What are host variables in db2?

624


What r the comman abends in db2, jcl and cobol???????

1818


What is null value in db2?

563


How can you find out the # of rows updated after an update statement?

637


Is db2 a database?

572


What is query_cache_limit?

541


What is an instance database?

598


Why do we need reorg in db2?

558


What is db2 instance?

590