摘要：select *from Awhere id in (select id from A group by id having count(1) >= 2) 注释：id 为重复的关键字（更换成所需要的） 开发实例： select CarlotName ,CheweiIDfrom Position_Ca 阅读全文

摘要：SELECT *FROM A LEFT OUTER JOIN B ON A.ID = B.IDWHERE B.ID IS NULL 开发实例： SELECT Position_Car.Area, Position_Car.CarMapNum, Position_Car.CheweiID, Posit 阅读全文