–根据表的自增列删除重复数据并保留一条数据 id是自增列,Hkscryk_id是重复数据列
DELETE
FROM
DBPWH..Hkscryk
WHERE
Hkscryk_id IN ( SELECT Hkscryk_id FROM DBPWH..Hkscryk GROUP BY Hkscryk_id HAVING count( Hkscryk_id ) > 1 ) -- 过滤出重复的dname
AND id NOT IN ( SELECT min( id ) AS id FROM DBPWH..Hkscryk GROUP BY Hkscryk_id HAVING count( Hkscryk_id ) > 1 ) -- 过滤出不在需要保留的id之外的所有id