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 query_cache_limit?

541


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2044


How to execute stored procedures?

620


What is buffer pool and list some of them?

628


What is cloudant database?

641






How to get the ddl of a table in db2?

675


what is utility for parm lib

1873


Which component is responsible for processing sql statements and selecting access paths?

666


What is the clustering index in the db2 database?

582


What does sqlcabc has?

629


Explain various types of locks in db2?

689


Which components manage deadlocks in db2?

609


What is the difference between oracle and db2?

584


What is the maximum length of sqlca?

869


What is universal database?

617