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
5418 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 is view db2?

1004

What is buffer pool and list some of them?

980

Explain about dbrm.

987

How to run db2 command in windows?

1135

What does reorg do in db2?

983

What is meant by dclgen?

1060

Explain the function of data manager.

990

How do we specify index to include or not during bind process.

2069

What is the syntax for creating a table in the db2 database?

1057

Is db2 relational database?

914

What is package in cobol db2?

1075

What are the rules for db2 programming?

1040

What is db2 bind?

1015

What is the syntax for FETCH in DB2 ?

1137

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

976