如何选择具有重复内容的行? [英] How to select rows with duplicate content?

问题描述

我有一个电子邮件表格，我想选择重复多次的电子邮件:

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?

推荐答案

按 email 分组，并只选择每组具有多于一条记录的那些

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

这篇关于如何选择具有重复内容的行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！