8000 update : fix the format · h-j-13/LeetCode-Database@cbe1e86 · GitHub
[go: up one dir, main page]

Skip to content

Commit cbe1e86

Browse files
committed
update : fix the format
1 parent 38c9dcc commit cbe1e86

File tree

1 file changed

+4
-3
lines changed

1 file changed

+4
-3
lines changed

Soulution/LeetCode-182--Duplicate-Emails.md

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -28,16 +28,17 @@ Note: All emails are in lowercase.
2828
## 解题思路
2929
* GROUP BY HAVING
3030
```SQL
31-
SELECT `Email` FROM `Person` GROUP BY `Email` HAVING COUNT(*) > 1
31+
SELECT `Email` FROM `Person` GROUP BY `Email` HAVING COUNT(*) > 1
3232
```
3333

3434
* 做笛卡尔积
3535

36-
* DISTINCT
36+
1. DISTINCT
3737
```SQL
3838
SELECT DISTINCT t1.`Email` FROM `Person` AS t1, `Person` AS t2 WHERE t1.id != t2.id and t1.`Email` = t2.`Email` ```
3939
```
40-
* INNER JOIN
40+
41+
2. INNER JOIN
4142

4243
```SQL
4344
SELECT DISTINCT p.Email FROM Person p INNER JOIN Person q ON p.Id != q.Id AND p.Email = q.Email;

0 commit comments

Comments
 (0)
0