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
- 10301 Views
- I also Faced
- E-Mail Answers
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
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Which command is used to connect to a database in DB2 ? Give the Syntax.
What r the comman abends in db2, jcl and cobol???????
What is a bind in db2?
How will you return the number of records in table?
What are the 2 sqlcodes that are returned?
What is view db2?
What does db2 blu stand for?
What are the two types of logging in the db2 database? Explain them.
What is reorg and runstats in db2?
Explain packages.
What is explain in db2?
How to find the maximum value in a column in the db2 database?
What are union and union all?
What is syscat in db2?
