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 will fetch last 5 rows from table in db2

Answer Posted / vaneesh khurana

Hi Harsha,

There is nothing to do with multiple of 5.
Simply declare the array of occours of 5 keep on filling
it when 6th record comes start over writing it from 1st.

At last we only left with the last 5 fetched rows.

Vaneesh Khurana

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to take backup of table in db2?

1029


What is the difference between nvl and coalesce?

1022


How do you pull up a query which was previously saved in qmf?

1112


What is difference between alias and synonym in db2?

1086


Name the lockable units in DB2?

1083


What is with ur in db2?

1258


What is the result of open cursor statement?

1043


How do you simulate the explain of an embedded sql statement in spufi/qmf?

1051


How to execute stored procedures?

1076


Define db2 and its databases?

1021


What is the use of dclgen in db2?

1024


List down the types of triggers in the db2 database?

976


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2188


How do you find the maximum value in a column in db2?

1072


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

994