File tree 1 file changed +3
-2
lines changed 1 file changed +3
-2
lines changed Original file line number Diff line number Diff line change @@ -26,14 +26,15 @@ Note: All emails are in lowercase.
26
26
题目大意:编写一个SQL查询从Person表中找出所有重复的邮箱地址。
27
27
28
28
## 解题思路
29
- * GROUP BY HAVING
29
+ GROUP BY HAVING
30
30
``` SQL
31
31
SELECT ` Email` FROM ` Person` GROUP BY ` Email` HAVING COUNT (* ) > 1
32
32
```
33
33
34
34
* 做笛卡尔积
35
35
36
36
1 . DISTINCT
37
+
37
38
``` SQL
38
39
SELECT DISTINCT t1.` Email` FROM ` Person` AS t1, ` Person` AS t2 WHERE t1 .id != t2 .id and t1.` Email` = t2.` Email` ` ` `
39
40
` ` `
@@ -48,5 +49,5 @@ SELECT DISTINCT p.Email FROM Person p INNER JOIN Person q ON p.Id != q.Id AND p.
48
49
49
50
# # GROUP BY HAVING 官方文档
50
51
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 ) 数据分组(聚合)
52
53
[HAVING ](https:// dev .mysql .com/ doc/ refman/ 5 .7 / en/ group- by- modifiers .html ) 数据聚合后的筛选
You can’t perform that action at this time.
0 commit comments