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

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10761


What is the difference between db2 and oracle?

673


What is universal database?

617


What does db2 plan contain?

573


What is commit in db2?

593






List out the buffer pools in db2

626


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1576


Is the primary key a clustered index?

608


How to create db2 table in mainframe?

629


How do you find the maximum value in a column in db2?

648


Name the lockable units in DB2?

663


Define sqlca.

647


What is a buffer in memory?

598


How to access db2 tables in mainframe?

611


What is netezza database?

573