how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,

---

What is the max length of sqlca?

0 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

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

5 Answers   DELL, HCL,

---

Which catalog table stores referential constraints?

1 Answers  

---

What is a SELECT statement?

1 Answers  

---

What is the syntax required for the creation of a cursor?

1 Answers  

---

What is difference between rollback and commit?

0 Answers  

---

How to compare data between two tables in db2?

0 Answers  

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

---

What is the role of the data page in the db2 database?

0 Answers  

---