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 the use of value function?

728


Name the lockable units in DB2?

759


What is the difference between spufi and qmf?

716


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

701


Who uses db2?

658






What is a bind card?

770


What is db2 stogroup?

780


What is dbrm? What it contains?

789


What is catalog database in db2?

749


What is view db2?

721


What is reorg?

694


Why do we use cursor?

681


What is package in db2 mainframe?

637


What is the physical storage length of date data type?

857


What is load replace in db2?

641