统计重复记录
SELECT [CustomName],count(1)
FROM [dim].[Custom]
group by [CustomName]
having count(1)>1
order by [CustomName]
显示全部重复记录
SELECT * FROM [dim].[Custom]
WHERE [CustomName] IN ( SELECT [CustomName] FROM [dim].[Custom] group by [CustomName] having count(1)>1)
order by [CustomName]