SQL

select duplicates in sql

SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1

SQL Duplicates by Composite

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