select * from (select * from emp a where rowid<(select max(rowid) fro

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 / parthasarathi

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What are db2 tables?

1067

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2021

Are view updateable?

994

What is db2?

1135

What is multi row fetch in db2?

1001

How can we retrieve the total number of records in RPG & CLLE?

595

What do you mean by cursor?

953

What is host variable?

1025

What are concurrency issues?

1042

Explain correlated sub-queries.

986

What is db2 bind process?

1198

If I have a view which is a join of two or more tables, can this view be updateable?

1096

What is the clustering index in the db2 database?

964

How do I add a column to a table in db2?

1062

What is precompiler in db2?

971