SELECT column1, column2, COUNT(*) as 'Count' FROM tablename GROUP BY column1, column2 HAVING Count(*) > 1 ORDER BY [Count] DESC;