from A where id in (select id from A group by id having count(1) >= 2)
注释：id 为重复的关键字（更换成所需要的）
开发实例：
select CarlotName ,CheweiID from Position_Car a where a.CarlotName in (select CarlotName from Position_Car b group by b.CarlotName having count(1) >= 2)
