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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / s

A Matching Index scan with equal predicate on a Unique
index will return only one row.

Is This Answer Correct ?    1 Yes 1 No

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

Answer / shankar

When you use CURSORS in your program.

or

when you use FETCH FIRST (n) ROW ONLY option on your SELECT
statement.

Is This Answer Correct ?    1 Yes 2 No

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

Answer / shekhar

when u use column function without using group by clause. it will give only single value. PLz correct if i m wrong.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More DB2 Interview Questions

Define db2 and its databases?

0 Answers  


what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,


Who uses db2?

0 Answers  


How to update more then one record using update?

5 Answers   IBM,


What is an access path?

3 Answers  






can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,


How will you delete duplicate records from a table?

7 Answers   Google,


Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  


What is cloudant database?

0 Answers  


What are common abends

1 Answers   SPIC, Virtusa,


what is the soft code for deadlock ?

2 Answers   Logica CMG,


What is the SQL Communications Area and what are some of its key fields?

1 Answers  


Categories