Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to get duplicate records with multiple field in sql

SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1
 
PREVIOUS NEXT
Tagged: #duplicate #records #multiple #field #sql
ADD COMMENT
Topic
Name
7+6 =