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
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
Define sqlca.
How to execute stored procedures?
What is alias in db2?
What is db2?
What is ibm db2 client?
What is runstats db2?
What is the reason behind not using select * in embedded sql programs?
What is the difference between cursor and select statement?
What is dbrm? What it contains? When it will be created?
What is the maximum size of varchar data type in db2?
Define data page.
What is a cursor in programming?
What is db2 bind?
What is reorg?
If I have a view which is a join of two or more tables, can this view be updateable?