Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Answers were Sorted based on User's Feedback



query to just fetch first matching row and stop execution. once one matching row is found ..no more..

Answer / romeu viegas

Select ...
FROM ...
WHERE ...
FETCH FIRST 1 ROW ONLY

Is This Answer Correct ?    3 Yes 1 No

query to just fetch first matching row and stop execution. once one matching row is found ..no more..

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

More DB2 Interview Questions

What are PACKAGES ?

3 Answers  

Name some fields from SQLCA.

2 Answers  

Can SQL statements/queries be included in a copybook?

2 Answers  

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

How to design maps

1 Answers   Virtusa,

what are stage one indexable predicates?

1 Answers  

What is the latest version of ibm db2?

0 Answers  

What is the maximum size of varchar data type in db2?

0 Answers  

Explain about rct in db2?

0 Answers  

What is rebind in db2?

0 Answers  

How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  

For more DB2 Interview Questions Click Here
Categories