Interested to Buy Any Domain ? << Click Here >> for more details...
quary for
1> fetch last record
2> fetch in reverse order
3> fetch last 5 row
4> fetch second last record (their is no primary key)
i think concept of count can be use for this in 4th
- 5 Answers
- 10491 Views
- I also Faced
- E-Mail Answers
Answer Posted / pavan
the above one is for fetching last record and i think u can
decraese (use < symbol) the count and use it for fetching
nth record in a table.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Is db2 a mainframe database?
What is the difference between bind and rebind in db2?
What is the physical storage length of date data type?
Is db2 free?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is a db2 tablespace?
What is host variable?
How and when does the db2 enforces the unique key?
What is db2 connect?
What is coalesce in db2?
What is difference between isnull and coalesce?
How do I create a view in db2?
Who uses db2?
What is consistency token in db2?
On which levels locks can be applied?
