查出table中的紀錄中哪些欄位重複

Select *, count(*) as 重複次數
from table
group by A,B,C,D
having count(*)>1