Cacher is the code snippet organizer for pro developers

SELECT    t.TableName,t.FieldName, COUNT(t.TableName) AS dup_count 
FROM         MLTableRaw t
GROUP BY t.TableName,t.FieldName
HAVING     (COUNT(t.TableName) > 1) 

SELECT    t.RowHash, COUNT(t.RowHash) AS dup_count 
FROM         sym.dimTransactions t
GROUP BY t.RowHash
HAVING     (COUNT(t.RowHash) > 1)