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
- 8651 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 can you find out the # of rows updated after an update statement?
What is the difference between static and dynamic SQL?
Is db2 a database?
Comment whether the cursor is closed during commit or not.
What is the use of with ur in db2?
What is clone table?
How to execute stored procedure in db2 command editor?
What is the purpose of the DSNC transaction ?
What is the self-referencing constraint?
where can we use index and subscript ? with example ?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What are column-name qualifiers used?
COBOL 
