此查询将为您提供电子邮件地址及其使用次数的列表，最常用的地址在前。
SELECt email, count(*) AS cFROM TABLEGROUP BY emailHAVINg c > 1ORDER BY c DESC
如果要完整行：
select * from table where email in ( select email from table group by email having count(*) > 1)
此查询将为您提供电子邮件地址及其使用次数的列表，最常用的地址在前。
SELECt email, count(*) AS cFROM TABLEGROUP BY emailHAVINg c > 1ORDER BY c DESC
如果要完整行：
select * from table where email in ( select email from table group by email having count(*) > 1)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
