182. Duplicate Emails

原创 2016年08月30日 09:25:18

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 |
+---------+


SELECT DISTINCT a.Email AS Email
FROM Person a,Person b
WHERE a.Id!=b.Id AND a.Email=b.Email;

版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

LeetCode196. Delete Duplicate Emails

Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique...

Delete Duplicate Emails

Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique...

LeetCode OJ Duplicate Emails

Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Emai...

【Leetcode Database】Delete Duplicate Emails

题目: Write a SQL query to delete all duplicate email entries in a table named Person, keeping on...

Emails

  • 2008-07-25 14:02
  • 52KB
  • 下载

Magento Transactional Emails常规设置

magento 允许我们自行管理电子邮件,修改电子邮件内容和设置电子邮件的一些参数。 我们从一个示例开始学习如何进行邮件管理:登入后台 System -> Transactional Emails ...

Kmp(求字符串公共循环节数目)——Common Divisors ( CodeForces 182D )

题目链接: http://codeforces.com/contest/182/problem/D 分析: 题意为给出两个字符串,求其公共循环节的数目,那么首先要求出其公共最小循环节!这里需要用到...
  • FeBr2
  • FeBr2
  • 2016-07-16 16:48
  • 401

(182)渐变

渐变函数以程序方式生成根据纹理坐标表达式产生的渐变。与创建基于纹理的渐变相比,这些函数可节省内存。 渐变函数 以下是渐变函数的列表。 指数径向渐变 RadialGradient...

Using VBScript to Send Emails with Gmail

I normally don’t post scripts and batch files that I use, but I wanted to share this particular scri...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)