select haoma from tb group by haoma having count(1) >= 3
create table tb(id int,haoma int) insert into tb values(1 ,101) insert into tb values(2 ,102) insert into tb values(3 ,101) insert into tb values(4 ,101) insert into tb values(5 ,103) insert into tb values(6 ,101) insert into tb values(7 ,105) goselect haoma from tb group by haoma having count(1) >= 3 drop table tb/* haoma ----------- 101(所影响的行数为 1 行) */
select * from tb where haoma in(select haoma from tb group by haoma having count(1)>3)
select haoma from tb group by haoma having count(*)>3
insert into tb values(1 ,101)
insert into tb values(2 ,102)
insert into tb values(3 ,101)
insert into tb values(4 ,101)
insert into tb values(5 ,103)
insert into tb values(6 ,101)
insert into tb values(7 ,105)
goselect haoma from tb group by haoma having count(1) >= 3
drop table tb/*
haoma
-----------
101(所影响的行数为 1 行)
*/
select haoma from tb
group by haoma
having count(*)>3