Sql Server表中删除重复记录最简单方法(多字段重复)
[sql]
DELETE Sys_RlReport
WHERE Id NOT IN www.2cto.com
(SELECT MIN(Id) FROM Sys_RlReport
GROUP BY employeename,bus) order BY employeename,bus)
多字段重复，通过与最小化Id比较