8000 fix : a markdown format error · h-j-13/LeetCode-Database@aca5be4 · GitHub
[go: up one dir, main page]

Skip to content

Commit aca5be4

Browse files
committed
fix : a markdown format error
1 parent 3c765c0 commit aca5be4

File tree

1 file changed

+3
-2
lines changed

1 file changed

+3
-2
lines changed

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

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -26,14 +26,15 @@ Note: All emails are in lowercase.
2626
题目大意:编写一个SQL查询从Person表中找出所有重复的邮箱地址。
2727

2828
## 解题思路
29-
* GROUP BY HAVING
29+
GROUP BY HAVING
3030
```SQL
3131
SELECT `Email` FROM `Person` GROUP BY `Email` HAVING COUNT(*) > 1
3232
```
3333

3434
* 做笛卡尔积
3535

3636
1. DISTINCT
37+
3738
```SQL
3839
SELECT DISTINCT t1.`Email` FROM `Person` AS t1, `Person` AS t2 WHERE t1.id != t2.id and t1.`Email` = t2.`Email` ```
3940
```
@@ -48,5 +49,5 @@ SELECT DISTINCT p.Email FROM Person p INNER JOIN Person q ON p.Id != q.Id AND p.
4849

4950
## GROUP BY HAVING 官方文档
5051

51-
[GROUP BY](https://dev.mysql.com/doc/refman/5.7/en/group- 416F by-functions.html) 数据分组(聚合)
52+
[GROUP BY](https://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html) 数据分组(聚合)
5253
[HAVING](https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html) 数据聚合后的筛选

0 commit comments

Comments
 (0)
0