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

10 Answers   IBM,

---

What is dbrm in db2 database?

0 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

How can you classify the locks in db2?

0 Answers  

---

What is a DBRM, PLAN ?

3 Answers  

---

What is a db2 table?

0 Answers  

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

What is sqlcode -922 ?

2 Answers  

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

What is a result table?

1 Answers  

---