SQL查询语句,怎样查询重复数据

select id from A group by id having count(1) >= 2