å¯ç¨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)
ç»æå¦å¾ï¼