Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vaneeshh khurana
See there is no direct method to do so, but still if we want
last 5 rows only we can create a logic which is as follows.
1. Declare an array to save the fetch rows with occurs of 5.
2. Now fetch the rows and start saving in that array such
that when the count becomes 5 overwrite the 6th fetch in the
first occurs similarly the 7th fetch on the 2nd occur.
3. Now when all the fetching is done the array will contains
the last 5 fetched rows.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What does db2 plan contain?
Is db2 free?
Where can you declare a cursor in a cobol-db2 program?
What is db2 and what is the use of db2 optimizer?
What is runstats db2?
What is null in db2?
Describe major components of db2?
How to find the number of rows in db2 tables?
What parameters are used to control the free space in DB2?
What is bufferpool in db2?
Comment whether the cursor is closed during commit or not.
What is the clustering index in the db2 database?
What are catalog tables in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is dbrm?
