找出資料表中重複的資料

SELECT 欄位名稱A,COUNT(*) FROM member GROUP BY 欄位名稱A HAVING COUNT(*) > 1