Interested to Buy Any Domain ? << Click Here >> for more details...
When Can you be sure that a query will return only one row?
- 4 Answers
- 8518 Views
- IBM, I also Faced
- E-Mail Answers
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 fetch the last row from the table in SQL (db2)?
Can we update view in db2?
How to resolve -407 sql code in DB2?
What is rct?
What is node in db2?
What is the result of open cursor statement?
What is the difference between SYNONYM and ALIAS?
Q4. How will you get the count of record without using COUNT verb in query?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What is an asychronous write?
what is the use of bind parameter, Replace?
When is the results table for the query in a DECLARE CURSOR statement created?
COBOL 
