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>

How to view db2 table structure?

0 Answers  

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

Explain about rct.

0 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

Is db2 a database?

0 Answers  

---

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

2 Answers   IBM,

---

What is a storage group (stogroup)?

0 Answers  

---

What is the picture clause of null indicator variable?

0 Answers  

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

How does a cursor work?

0 Answers  

---