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
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?
How do I delete a column in db2?
What is the use of with ur in db2?
Can we delete records from view?
What is cursor in dbms?
What is dbrm? What it contains? When it will be created?
What is a page in db2?
Are views updateable?
Explain about open switch business continuity software?
How to take backup of table in db2?
What is sqlca?
What does db2 mean?
What are types of indexes?
Define check constraint.
How will you return the number of records in table?