Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

Name some fields from SQLCA

1 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

---

What is a DB2 bind?

3 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

What is reorg in database?

1 Answers  

---

What is image copy 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,

---

How to find the number of rows in db2 tables?

0 Answers  

---