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

What is dbrm? What it contains?

682


What is bufferpool in db2?

580


Which command is used to remove all rows from a table?

553


What is the use of commit in db2?

635


What are db2 tables?

649






What is the difference between using bind () and rebind () methods of naming class?

796


How and when does the db2 enforces the unique key?

615


Is db2 a mainframe?

589


What are db2 objects?

641


What is the use of db2 optimizer?

611


What are the prerogatives?

617


What is the difference between dbm cfg and db cfg file in db2 ?

1007


what is the responsibility of the construction superintendent

1664


What is a buffer in memory?

600


What is difference between isnull and coalesce?

620