Answer / nans

Select FIELD1 From <TABLENAME> As Temp Group By FIELD1 Having
Count(*) >1;

Answer / channabasappa

select field name from tablename where group by field name
having count(field name)>1;

Answer / mahesh vasudevan

Select <col-name> from table A1 and A2
where A1.Col = A2.Col.

This should be an inner join. Then you are finding the
intersection of the key values...if you want to find the
duplicates for all matching column of the rows code AND
condition for join with all those columns.....by the way
there are different easy ways to find it. but this is one of
the way.

Answer / pandu

select distinct from <field name> from <table name>

What is a thread?

3 Answers  

---

How do you define a correlated name?

1 Answers  

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers  

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

Define db2.

0 Answers  

---

What do the initials DDL and DML stand for and what is their meaning?

2 Answers  

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

How to take backup of table in db2?

0 Answers  

---

What is deadlock?

2 Answers  

---