Link
Search
Menu
Expand
Document
Hello LeetCode
Home
Algorithms
Easy
1. Two Sum
7. Reverse Integer
9. Palindrome Number
14. Longest Common Prefix
20. Valid Parentheses
21. Merge Two Sorted Lists
26. Remove Duplicates from Sorted Array
58. Length of Last Word
104. Maximum Depth of Binary Tree
112. Path Sum
121. Best Time to Buy and Sell Stock
167. Two Sum II - Input array is sorted
205. Isomorphic Strings
217. Contains Duplicate
268. Missing Number
278. First Bad Version
414. Third Maximum Number
561. Array Partition I
645. Set Mismatch
905. Sort Array By Parity
1295. Find Numbers with Even Number of Digits
1299. Replace Elements with Greatest Element on Right Side
1304. Find N Unique Integers Sum up to Zero
1534. Count Good Triplets
1588. Sum of All Odd Length Subarrays
1684. Count the Number of Consistent Strings
1863. Sum of All Subset XOR Totals
Medium
3. Longest Substring Without Repeating Characters
142. Linked List Cycle II
287. Find the Duplicate Number
1143. Longest Common Subsequence
Hard
4. Median of Two Sorted Arrays
827. Making A Large Island
Database
Easy
175. Combine Two Tables
176. Second Highest Salary
181. Employees Earning More Than Their Managers
182. Duplicate Emails
183. Customers Who Never Order
196. Delete Duplicate Emails
595. Big Countries
596. Classes More Than 5 Students
620. Not Boring Movies
627. Swap Salary
Database
Easy
182. Duplicate Emails
182. Duplicate Emails
Solution Code
MySQL
SELECT
Email
FROM
Person
GROUP
BY
Email
HAVING
COUNT
(
*
)
>
1
;