DB2 Select

[bearamg]

I need a DB2 Select statement that counts the number of Duplicate values for a paricular column?

thanks...

[ganeshmn25]

Hi ,

To count the number of duplicate values of a particular column in a table
you can make use of the following query,

SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )



Regards
Padmanaban.N
DB2 Associate