Hi,

I wonder if there any syntax or SQL statements that I could use to check for duplicate data in a table (e.g. temp table) ? Thks all in advance !!!

A really simple way would be to have DB2 count them.
SELECT cola,colb,colc,...,count(*) as qty from mytable group by cola,colb,colc,...

Those rows in the resultset with a QTY > 1 have duplicate rows.

HTH

Andy

andy, your sql is fine, but your closing statement is not

those rows in the resultset with qty > 1 have duplicate selected columns in the table

If all the columns are in the group by clause, then it would count the duplicate rows. That is why I used the ellipse (...) to signify that all columns should be specified.

Andy

To be more specific:

SELECT cola, colb, colc, count(*)
from mytable
group by cola, colb, colc
having count(*) > 1

thks guys for all the help