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

680


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

663


What is the latest version of ibm db2?

750


i want to maintain uniqueness on pdf without make lf??????????

1644


What is db2 command?

595






How to find the maximum value in a column in the db2 database?

623


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

641


What is db2 plan table?

635


What is the role of schema in the db2 database?

665


What is coalesce in db2?

691


What is host variable?

605


Explain the function done by data manager?

862


How to get the ddl of a table in db2?

687


What action db2 takes when a program aborts in the middle of a transaction?

671


What is query_cache_limit?

555