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  

---

Which command is used to remove all rows from a table?

0 Answers  

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

What is difference between alias and synonym in db2?

0 Answers  

---

What will the DB2 optimizer do?

2 Answers  

---

How and when does the db2 enforces the unique key?

0 Answers  

---

What is page size in db2?

0 Answers  

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---