How to select rows with duplicate content?

Question

I have a table of email, and I want to select emails that Repeated more than one time:

How can I just select rows (Emails) that repeated more than one time?

Answer 1

Group by email and select only those having more than one record per group

select email
from your_table
group by email
having count(*) > 1