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
5521 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 innodb buffer pool?

1048

What db2 400?

1171

Why cursor is used in db2?

1036

What is package in cobol db2?

1115

What are foreign keys in db2?

1100

What is the role of data manager in the db2 database?

1100

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1099

Explain various types of locks in db2?

1139

Explain what are the various isolation levels possible?

1041

What is a bind card?

1215

What is ibm db2 database?

998

How do I change the column size in db2?

1151

Explain correlated sub-queries.

1025

How to check table size in db2 sap?

1034

What is the function of logging in the db2 database?

1118