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
- 5531 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
What is the difference between cursor and select statement?
What is the use of predicate?
What is a db2 package?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Which component is used to execute the sql statements?
What is the difference between cursor stability and repeatable read isolation levels?
Highlight all the advantages that are attached to a package.
What is the use of db2?
What is scrollable cursor in db2?
How can you classify the locks in db2?
How can you find out the # of rows updated after an update statement?
What is phantom read in db2?
What is the physical storage length of time data type?
What is bind package and plan in db2?
What is performance tuning db2?
