删除数据库里重复的记录

select nn.aa from (
select max(s.Id), count(s.WorkOrderNo) as aa,WorkOrderNo from t_WorkOrder s group by s.WorkOrderNo,s.Id  ) nn
where nn.aa>1
delete from t_WorkOrder where Id not in(

//查询某个字段相同内容大于1的记录

select MAX(Id) as Id, WorkOrderNo, count(*) as co from t_WorkOrder group by WorkOrderNo HAVING count(*) > 1 )

//删除掉重复的记录

delete from t_WorkOrder where Id  in(
select Id from (

select min(Id) as Id, WorkOrderNo, count(*) as co from t_WorkOrder group by WorkOrderNo HAVING count(*) > 1 ) kk)

这种写法：这条语句需要执行好几次，直到没有重复的为止。