query to just fetch first matching row and stop execution. once one matching ro

query to just fetch first matching row and stop execution.
once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

Question Posted / srprev

2 Answers
4575 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

query to just fetch first matching row and stop execution. once one matching row is found ..no more..

Answer / romeu viegas

Select ...
FROM ...
WHERE ...
FETCH FIRST 1 ROW ONLY

Is This Answer Correct ?

3 Yes

1 No

query to just fetch first matching row and stop execution. once one matching row is found ..no more..

Answer / parthasarathi

select * from
(select * from emp a where rowid<(select max(rowid) from
emp b where a.empno=b.empno) x
where rownum=1

Is This Answer Correct ?

0 Yes

1 No

Post New Answer