Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

SQL Duplicates by Composite

SELECT column1, column2, COUNT(*) as 'Count' 
FROM tablename 
GROUP BY column1, column2 
HAVING Count(*) > 1
ORDER BY [Count] DESC;
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #SQL #Duplicates #Composite
ADD COMMENT
Topic
Name
9+2 =