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 a db2 schema?

764


What is the usage of open cursor command?

599


Describe major components of db2?

641


What is rct?

751


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

713






What is innodb buffer pool?

564


Explain package in db2 and its advantages?

597


What is cloudant database?

643


What are the two types of logging in the db2 database? Explain them.

582


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3120


Which are the db2 tools to protect integrity of the database?

692


How and when does the db2 enforces the unique key?

615


B37 abend during spufi?

982


What is dclgen (declaration generator)?

603


When do you specify the isolation level?

608