When Can you be sure that a query will return only one row?

Answer Posted / shailendra

when you will retrive the record on the basis of primary key
for the perticuler record.

as like
select * from table_name where acct_no =2345678754332

the above given answeris also right

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1761


How do I delete a column in db2?

792


What is the use of with ur in db2?

732


Can we delete records from view?

690


What is cursor in dbms?

734






What is dbrm? What it contains? When it will be created?

713


What is a page in db2?

718


Are views updateable?

777


Explain about open switch business continuity software?

719


How to take backup of table in db2?

712


What is sqlca?

743


What does db2 mean?

706


What are types of indexes?

703


Define check constraint.

758


How will you return the number of records in table?

637