if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

How to access db2 tables in mainframe?

0 Answers  

---

What is declare cursor?

0 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

---

What is index cardinality?

3 Answers  

---

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

What are the contents of dclgen?

0 Answers  

---

What is dbrm library?

0 Answers  

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

What is multi row fetch in db2?

0 Answers  

---