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
- 10583 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 package in cobol db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the physical storage length of date data type?
Explain in brief how does db2 determine what lock-size to use?
Mention the various locks that are available in db2.
Explain what are the various isolation levels possible?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is a db2 table?
How does a cursor work?
Define sqlca.
What is db2 and what is the use of db2 optimizer?
What is the max length of sqlca?
How to find the number of rows in a db2 table?
What is buffer pool in the db2 database?
What is sqlca’s maximum length?
