Question

sql筛选出记录数大于2的记录

比如
id name
1 xx
2 xx

3 xx
4 xx
5 xx
1 xx
2 xx
9 xx

筛选出id重复的记录数大于2的id（也就是1和2），怎么写？

Answer 1

select id,count(*) from 表
group by id
having count(*)>=2

Answer 2

select * from #pp where id in (select id from #pp group by id having count(*)>2)

这样即可实现该功能！

追问

SELECT * FROM SYS_SERVST WHERE custid in(SELECT custid FROM sys_servst GROUP BY custid HAVING servkind=1 AND permark=3 AND COUNT(*)>2);

这个sql有错吗？为什么报错说不是group by表达式？

追答

关键是根本就没有这样的写法，请知悉！

Answer 3

id重复且大于2
select * from 表名 where id in(select id from 表名 where count（id）>1 group by id)and id>2
id大于2

select * from 表名 where id>2