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>

Name some fields from SQLCA.

2 Answers  

---

why we create view.

5 Answers  

---

How do I start db2 in windows?

0 Answers  

---

What is a correlated sub query?

2 Answers  

---

How to update more then one record using update?

5 Answers   IBM,

---

Why do we need reorg in db2?

0 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

What is cursor stability?

1 Answers  

---

What is the use of value function?

0 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

What do you mean by commit and rollback?

0 Answers  

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

---