sql leetcode 182. Duplicate Emails
来源:互联网 发布:单片机应该怎么学 编辑:程序博客网 时间:2024/06/05 11:17
Write a SQL query to find all duplicate emails in a table named Person
.
+----+---------+| Id | Email |+----+---------+| 1 | a@b.com || 2 | c@d.com || 3 | a@b.com |+----+---------+
For example, your query should return the following for the above table:
+---------+| Email |+---------+| a@b.com |+---------+
Note: All emails are in lowercase.
这道题是一道sql题。大神这样做:SELECT distinct p1.Email from Person p1INNER JOIN Person p2ON p1.Email = p2.EmailWHERE p1.Id <> p2.Id;
这道题有solution:https://leetcode.com/problems/duplicate-emails/solution/Solution
Approach I: Using GROUP BY
and a temporary table [Accepted]
Algorithm
Duplicated emails existed more than one time. To count the times each email exists, we can use the following code.
select Email, count(Email) as numfrom Persongroup by Email;
| Email | num ||---------|-----|| a@b.com | 2 || c@d.com | 1 |
Taking this as a temporary table, we can get a solution as below.
select Email from( select Email, count(Email) as num from Person group by Email) as statisticwhere num > 1;
Approach II: Using GROUP BY
and HAVING
condition [Accepted]
A more common used way to add a condition to a GROUP BY
is to use the HAVING
clause, which is much simpler and more efficient.
So we can rewrite the above solution to this one.
MySQL
select Emailfrom Persongroup by Emailhaving count(Email) > 1;
阅读全文
0 0
- [leetcode][SQL]182. Duplicate Emails
- sql leetcode 182. Duplicate Emails
- Duplicate Emails Leetcode SQL
- leetcode 182. Duplicate Emails
- leetcode.182. Duplicate Emails
- leetcode 182. Duplicate Emails
- leetcode 182. Duplicate Emails
- Leetcode 182. Duplicate Emails
- 【LeetCode】182. Duplicate Emails
- 【leetcode Database】182. Duplicate Emails
- leetcode数据库sql之Delete Duplicate Emails
- LeetCode笔记:(MySQL) 182. Duplicate Emails
- [LeetCode][Database]Duplicate Emails
- LeetCode OJ Duplicate Emails
- LeetCode Delete Duplicate Emails
- 【Leetcode Database】Duplicate Emails
- Duplicate Emails LeetCode
- Delete Duplicate Emails LeetCode
- Treap
- ORACLE sql调优之记录一次trim函数引发的大表全表扫描
- 程序猿(媛)们注意啦!Git、SVN、Mercurial版本控制系统被爆远程命令执行漏洞
- java 把字符串里的 斜杠 都变成 分隔符
- 51Nod
- sql leetcode 182. Duplicate Emails
- python的字符串驻留
- Swing制作表格鼠标获取所选行的代码
- mybatis多表关联查询的问题
- Matlab新建一个按钮中CreateFcn和Callback的区别是什么?
- mybatis框架之 user.xml 配置
- Android7.0的FileProvider适配
- HDU 1709 (母函数)
- phantomjs安装方法