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
- 8789 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 |
Is db2 free?
what is the soft code for deadlock ?
What are the bind parameters ibm db2?
What is performance tuning db2?
What is the latest version of ibm db2?
What is meant by index cardinality?
What is RUNSTATS?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
Why do chiropractors use drop table?
What is the difference between Where and Having Clause
What is db2 purescale?
what is the Foreign key? explain?
COBOL 
