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', 'a@b.com') insert into Person (id, email) values ('2', 'c@d.com') insert into Person (id, email) values ('3', 'a@b.com')

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:

LeetCode Solution, Easy, 182. Duplicate Emails

Comments

LeetCode Solution

LeetCode Solution, Easy, 511. Game Play Analysis I

More from this blog

如何開始入門軟體工程領域 - 名詞解釋（長期更新）

我的 MacBook Pro (Apple Silicon) 設定

ChatGPT 下的發展預想

一些覺得有用的工具蒐藏

LeetCode Solution, Medium, 607. Sales Person

182. Duplicate Emails

題目敘述

題目翻譯

解法解析

解法範例

MySQL

Command Palette

Comments

LeetCode Solution

LeetCode Solution, Easy, 511. Game Play Analysis I

More from this blog

182. Duplicate Emails

題目敘述

題目翻譯

解法解析

解法範例

MySQL