表A,有字段:no,time,name
从表A中查询出name出现过3次以上的所有数据!
=========================================
select * from A
where name in
(
select name from A group by name having count(*)>=3
)
从表A中查询出name出现过3次以上的所有数据!
=========================================
select * from A
where name in
(
select name from A group by name having count(*)>=3
)
select * from a where name in
(select name from a group by name having count(1) > 3)