Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 5634 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
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Who uses db2?
What type of database is db2?
What does reorg do in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Explain about rct.
Explain various types of locks in db2?
What is scrollable cursor in db2?
What action db2 takes when a program aborts in the middle of a transaction?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How do I add a column to an existing table in db2?
When do you specify the isolation level?
What do you mean by cursor?
How to find the number of rows in db2 tables?
What is the difference between dbm cfg and db cfg file in db2 ?
