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,

---

What os does db2 run on?

0 Answers  

---

What is dbrm? What it contains?

0 Answers  

---

Mention data types used in db2 ?

0 Answers  

---

How can you quickly find out the # of rows updated after an update statement?

0 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

---

What is commit in db2?

0 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

What is EXPLAIN?

1 Answers  

---