How Do I Find Only Duplicate Entries In A Database Table?

1.	How Do I Find Only Duplicate Entries In A Database Table?
Answer» RAILS: User.group(:EMAIL).having("count(email)>1 Mysql: SELECT * from USERS group by first,email having count() > 1 Rails:* User.group(:email).having("count(email)>1 Mysql: select * from users group by first,email having count(*) > 1

Answer»

RAILS: User.group(:EMAIL).having("count(email)>1

Mysql: SELECT * from USERS group by first,email having count(*) > 1

Rails: User.group(:email).having("count(email)>1

Mysql: select * from users group by first,email having count(*) > 1

Discussion