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
- 10785 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 role of union all and union
How do I copy a table in db2?
What is query_cache_limit?
What is cursor stability in db2?
How to create backup table in db2?
What is database manager in db2?
How do I add a column to a table in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is rct?
What is db2 bind?
What is the use of with ur in db2?
What is dbrm in db2 database?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How do I add a column in db2?
What are the 2 sqlcodes that are returned?
