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
What is a db2 tablespace?
What is the reason behind not using select * in embedded sql programs?
Explain what are the various isolation levels possible?
What is db2? Explain.
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?
What is a trigger in the db2 database?
What is the role of schema in the db2 database?
Why do we need reorg in db2?
What is runstats db2?
How to get the ddl of a table in db2?
What is collection in db2 bind?
When the like statement is used?
What is package in cobol db2?
What is a db2 schema?
What is an instance in db2?