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

Define data page.

1011


Which are the db2 tools to protect integrity of the database?

1070


What is the difference between using bind () and rebind () methods of naming class?

1324


Explain the function of data manager.

988


what is a corelated subquerry?

1062


What do you mean by between and in? Is between inclusive of specified range values?

1037


What are the contents of a dclmgen?

1066


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1309


How can you find out the # of rows updated after an update statement?

1050


What is dbrm library?

996


Explain how can you do the explain of a dynamic sql statement?

1062


What is blu acceleration in db2?

1013


what is db2 restart?

2100


Mention the downsides of page level lock.

1112


What is runstats utility in db2?

961