sql查询重复数据

select * from A where A.ID in (select  A.ID from A group by  A.ID having count(1) >= 2)

希望大家有更好的丢出来