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

What are iseries servers?

1068


What is load utility in db2?

1175


Is ibm db2 free?

998


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1069


What does db2 plan contain?

1013


What is temporal table in db2?

1027


What is access path in db2?

976


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2523


How can you do the explain of a dynamic sql statement?

1062


What is the connection string to connect to the DB2 Database ?

1108


What is the use of db2 optimizer?

1099


How does a cursor work?

972


What is the use of runstats in db2?

1097


What is the information associated with sysibm.syslinks table?

1119


How to connect to db2 database from windows command line?

1047