--删除重复数据delete from PMS_Contract_LeasedRoom where LeasedRoomId not in(select max(LeasedRoomId) from PMS_Contract_LeasedRoom group by ContractCode,RoomCode) --having count(*)>1)
sql删除重复数据
原文：http://www.cnblogs.com/howie/p/4708929.html
