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 Declaration Generator(DCLGEN)?

1 Answers  

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

What is REORG? When is it used?

4 Answers  

---

How do you pull up a query which was previously saved in qmf?

0 Answers  

---

How to check last update on table in db2?

0 Answers  

---

what is the difference between join and union?

4 Answers   IBM,

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

What is meant by repeatable read?

4 Answers  

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

Explain transactions, commits and rollbacks in DB2.

3 Answers  

---