去重sql 留下相同数据中id最小的数据

留下相同数据中id最小的数据

UPDATE TableName SET IsDeleted = 1 WHERE Id NOT IN (
    SELECT MIN(Id)
    FROM TableName     
    GROUP BY 查重字段A, 查重字段B
);