攻城獅
Not a programmer 不工程的攻城獅

Follow

Not a programmer 不工程的攻城獅

Follow

LeetCode Solution, Easy, 182. Duplicate Emails

攻城獅's photo
攻城獅
·Feb 2, 2023·
Play this article

182. Duplicate Emails

題目敘述

SQL Schema >

Create table If Not Exists Person (id int, email varchar(255)) Truncate table Person insert into Person (id, email) values ('1', '') insert into Person (id, email) values ('2', '') insert into Person (id, email) values ('3', '')

Table: Person

+-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-------------+---------+ id is the primary key column for this table. Each row of this table contains an email. The emails will not contain uppercase letters.

Write an SQL query to report all the duplicate emails.

Return the result table in any order.

The query result format is in the following example.

Example 1:

Input: Person table: +----+---------+ | id | email | +----+---------+ | 1 | | | 2 | | | 3 | | +----+---------+ Output: +---------+ | Email | +---------+ | | +---------+ Explanation: is repeated two times.

題目翻譯

解法解析

解法範例

MySQL


 
Share this