SELECT `重複を調べるカラム名` , COUNT( * )
FROM `テーブル名`
GROUP BY `重複を調べるカラム名`
HAVING COUNT( * ) >1