Comparing values with a single query

[amrigo]

Hi

Using mysql is there any query we can build to compare values in a collumn to see if there is no duplicated values.

A query like somecollumn .. not unique ... and this query returns all the lines with duplicated values to a given collumn?

Thank´s in advance

[sknake]

select primaryKey, count(*) as cnt
from table
group by primaryKey
having cnt > 1