There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---

What is null in db2?

0 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  

---

how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,

---

What is a page?

2 Answers  

---

What is with ur in db2?

0 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---