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...

how to fetch first 100 rows in db2

Answer Posted / jagan

select top 100 from tableName;

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the downsides of page level lock.

1122


Why do we need reorg in db2?

938


What does sqlcabc has?

1014


How would you find out the total number of rows in a db2 table?

1007


What is collection in db2 bind?

977


What is dbrm? What it contains? When it will be created?

1006


What is explain plan in db2?

949


Define sqlca.

1073


What is a db2 table?

976


How do you select a row using indexes in db2?

1087


How to check last update on table in db2?

1020


What is dbrm? What it contains?

1125


How does cobol compile db2 program?

1023


What are foreign keys in db2?

1055


Explain the contention situations caused by locks?

1026