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 the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

How would the varchar column remarks defined?

0 Answers  

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

Explain the use of the WHERE clause?

1 Answers  

---

How do I change the column size in db2?

0 Answers  

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---

Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---

How do I delete a table in database?

0 Answers  

---

How to connect to db2 database from windows command line?

0 Answers  

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---