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  

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

What is Reorg Recovery? when will you run it?

2 Answers  

---

What is the maximum size of a char data type in db2?

0 Answers  

---

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---

Are view updateable?

0 Answers  

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

What is pagespace?

1 Answers  

---