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
List down the types of triggers in the db2 database?
What is coalesce in db2?
How to find the number of rows in a db2 table?
How do I import a csv file into db2?
Name the various locking levels available?
What is db2 catalog database?
When do you specify the isolation level?
is it compulsory commitment control in journal?
What is the role of schema in the db2 database?
What is the use of dclgen in db2?
What is db2 instance?
What is a Foreign Key?
Why select is not preferred in embedded sql programs?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is the use of reorg in db2?