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 is node in db2?

811


Who uses db2?

764


What is database manager in db2?

757


Explain what are the various isolation levels possible?

798


What is the use of value function?

842


How to take backup of table in db2?

811


How to find the number of rows in db2 tables?

805


What is bind plan?

800


Is db2 a programming language?

793


What is the max length of sqlca?

963


What is the information associated with sysibm.syslinks table?

880


What is db2 command?

773


How do I import data from excel to db2?

831


Define predicate?

861


What is the latest version of ibm db2?

968