sql查询指定列超过一定条数的记录

select * from tb_name where id in (
select id from tb_name group by id having count(0) > 1
)


select id,count(0)  from tb_name group by id having count(0) > 1


select id,count(0)  from tb_name group by id