Question

查询table a中name字段值重复3次以上的所有数据SQL语句怎么写啊?

Answer 1

为什么楼上要用个关联查询呢？

select name from table_a group by name having count(name)>3

Answer 2

select * from a ,(select name,count(name) frrom table a
group by name
having count(name)>=3) b
where a.name=b.name