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 foreign keys?

1 Answers  

What is copy book?

1 Answers   Thomson Reuters,

What is a DB2 access path?

1 Answers  

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

What is isolation level in db2?

0 Answers  

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

What are the contents of a DCLGEN?

4 Answers   MetLife,

What are union and union all?

0 Answers  

what is consistency token

3 Answers  

For more DB2 Interview Questions Click Here
Categories