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
please try this one and let me know....
select * from emp where :ws-rec-cnt = (select Count(*)
into :ws-rec-cnt from emp);
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the difference between oracle and db2?
What is a db2 package?
What is the maximum No of rows per page?
What kind of database is db2?
What does reorg do in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How do I delete a table in database?
Define predicate?
what are bind concepts in db2 cobol?
What is null indicator in cobol db2?
What is db2?
How to execute stored procedures?
What is bind and rebind in db2?
What is innodb buffer pool?
How to restart a DB2 program?