When Can you be sure that a query will return only one row?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Is db2 a mainframe?
What is the physical storage length of the data types date, time, and timestamp?
How can you display the current date & current time ?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What is the physical storage length of timestamp data type?
What is universal database?
How do you check for a null value in a db2 column?
What is the difference between static and dynamic SQL?
What are iseries servers?
What information is held in SYSIBM.SYSCOPY?