Answers for "Which query is correct to find the duplicate records in the table?"

sql query to find duplicates in column

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

Posted by: Guest on June-01-2020

Code answers related to "Which query is correct to find the duplicate records in the table?"