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
- 8691 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 |
what is diffrence b/w file-aid tool and file-aid utility???
what is the Foreign key? explain?
Compare a subselect to a join?
How can you get the number of rows impacted by the last executed query?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What are catalog tables in db2?
Explain packages.
How do you define a correlated name?
Write a query to extract first 5 characters of a name in the column Stud_Name?
Explain correlated sub-queries.
select distinct(empid),distinct(dept),name from EMP will the above query work?
Explain in brief how does db2 determine what lock-size to use?
COBOL 
