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 do you retrieve the data from a nullable column?

2 Answers  

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

What is null indicator in db2?

0 Answers  

---

What is scrollable cursor in db2?

0 Answers  

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

What is the usage of open cursor command?

0 Answers  

---

what is consistency token

3 Answers  

---

Why cursor is used in db2?

0 Answers  

---

What is pagespace?

1 Answers  

---

What are the levels of isolation available with DB2V4

2 Answers   IBM,

---

What are leaf pages?

3 Answers  

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---