一、第一种方法删除数据库重复记录
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