sql查所有数据要求相同列值相等个数大于三的

select *
from tablename
where id in
(
select id
from tablename
group by id
having count(*) > 3
);

select count(*) num,id
from table group by id
having num >3

select id,count(id) sl into #b from a
group by id
having count(id)>3

select A.id,A.name from a A,#B B
WHERE A.id=B.id
group by A.id,A.name

考虑到id相同时name可能不同

select * from 表名
where id in (select id from 表名 group by id having count(*)>3)

楼上说的都不对，应该这样：

select id,name from a where id in (select id from a group by a having count(*)>3)