select column1, column2, column3, ... n, count(*) as [Number of Dupes]
from TableName
group by column1, column2, column3... n
having count(*) > 1