å¯ç¨group byâ¦â¦havingæ¥å®ç°ã
å¯åå¦ä¸æµè¯ï¼
1ãå建表æå
¥æ°æ®ï¼
create table test
(id int,
name varchar(10))
insert into test values (1,'å¼ ä¸')
insert into test values (2,'æå')
insert into test values (3,'å¼ ä¸')
insert into test values (4,'çäº')
insert into test values (5,'èµµå
')
å
¶ä¸nameæ¯å¼ ä¸çæ两è¡ï¼ä¹å°±æ¯éå¤è¡ã
2ãæ§è¡sqlè¯å¥å¦ä¸ï¼
select * from test where name in
(select name from test group by name having COUNT(*)>1)
ç»æå¦å¾ï¼
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/08f790529822720eb1efab8b7dcb0a46f21fab9a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)