【Leetcode Database】Duplicate Emails

最新推荐文章于 2018-01-10 19:17:11 发布

大家叫我陈老师

最新推荐文章于 2018-01-10 19:17:11 发布

阅读量344

点赞数

分类专栏： Leetcode Database MySQL 文章标签： leetcode mysql database sql

本文链接：https://blog.csdn.net/chenyancun2011/article/details/45506727

版权

32 篇文章 0 订阅

订阅专栏

4 篇文章 0 订阅

订阅专栏

2 篇文章 0 订阅

订阅专栏

题目：

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.

代码：

1 2	`# Write your MySQL query statement below` `select Email from Person group by Email having` `count` `(Email)>1`

此题考察group by 的having以及count(列名)的用法

（1）group by 具体请看http://www.cnblogs.com/rainman/archive/2013/05/01/3053703.html（这里讲的很详细）

（2）count(列名)是对列中不为空的行进行计数，如果某列有n个记录，m(m<=n)个记录为null，则count（该列）=n-m。

关注