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
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is difference between isnull and coalesce?
How do we specify index to include or not during bind process.
What r the comman abends in db2, jcl and cobol???????
Mention the location where the output received from explain statement is stored.
What's The Error Code For Unique Index Voilation?
What is dclgen in db2?
What is bind in db2?
How to create backup table in db2?
What is meant by union and union all?
What is the picture clause of null indicator variable?
What is database alias db2?
What is isolation level in db2?
How do I add a column to a table in db2?
Explain the function of data manager.