删除数据库重复记录

一、第一种方法删除数据库重复记录

WITH  b AS ( SELECT  ROW_NUMBER() OVER ( PARTITION BY stime ORDER BY stime ) AS rn,* FROM   dh1004)
DELETE  FROM b
--select * from b     --查询重复记录
WHERE  rn > 1

delete b from
--select * from       --查询重复记录
( SELECT  ROW_NUMBER() OVER ( PARTITION BY stime ORDER BY stime ) AS rn FROM  DH1004) b
where rn>1
 

转载于:https://blog.51cto.com/rosehacker/473911