Sql Server表中删除重复记录最简单方法（多字段重复）

DELETE Sys_RlReport     WHERE Id  NOT IN 

                    (SELECT MIN(Id) FROM Sys_RlReport  GROUP BY employeename,bus) order BY employeename,bus)

多字段重复，通过与最小化Id比较