When Can you be sure that a query will return only one row?

Question Posted / guest

4 Answers
7048 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When Can you be sure that a query will return only one row?..

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

When Can you be sure that a query will return only one row?..

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

When Can you be sure that a query will return only one row?..

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

When Can you be sure that a query will return only one row?..

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

Post New Answer