find duplicates in a table using SQL

Question

What would be a simple way to find duplicates in a table using SQL Select statement?

Answer 1

To find duplicate records
SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1

To delete the duplicate records in a table use the following link
https://www.sololearn.com/Discuss/274045/how-to-delete-duplicate-records-in-sql

Answer 2

thanks! i still dont understand the sql which delete the dup. Do you mind explain it further, please?

Answer 3

i understand now