How to select duplicate rows in SQL

Submitted 4 months, 3 weeks ago
Ticket #421
Views 103
Language SQL
Priority Low
Status In-Progress

This query will give us John, Sam, Tom, Tom because they all have the same email.

However, what I want is to get duplicates with the same email and name.

That is, I want to get "Tom", "Tom".

Submitted on Apr 27, 21
add a comment

2 Answers

This might help: FInd duplicates (https://chartio.com/learn/databases/how-to-find-duplicate-values-in-a-sql-table/)

Or, maybe stackoverflow (https://stackoverflow.com/questions/4522431/find-duplicate-entries-in-a-column)

Submitted 4 months, 3 weeks ago

There are many ways to do this,

one of them below,

SELECT a.*
FROM users a
JOIN (SELECT username, email, COUNT(*)
FROM users 
GROUP BY username, email
HAVING count(*) > 1 ) b
ON a.username = b.username
AND a.email = b.email
ORDER BY a.email

Submitted 4 months, 2 weeks ago


Wanna Post Ad?
Reach a large group of audience by posting an ad about your business here. For more details
Drop us a Message