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
- 10568 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
What is the max length of sqlca?
What is temporal table in db2?
What are host variables in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is an instance database?
Can there be more than one cursor open for any program?
Define check constraint.
What is db2 optimizer?
Explain the function done by data manager?
What is buffer pool and list some of them?
What is db2 purescale?
What is the use of runstats in db2?
What language is db2 written in?
What is lock escalation in db2?
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 ?
