摘要: select *from Awhere id in (select id from A group by id having count(1) >= 2) 注释:id 为重复的关键字(更换成所需要的) 开发实例: select CarlotName ,CheweiIDfrom Position_Ca 阅读全文
posted @ 2016-07-29 17:19 肥皂泡泡oO 阅读(128) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2016-07-29 17:12 肥皂泡泡oO 阅读(795) 评论(0) 推荐(0) 编辑