DELETE
FROM
hl_orbit_ecf_result #表
WHERE
liyuanDate IN ( # 删除 条件
SELECT
a.liyuanDate
FROM
( SELECT count( liyuanDate ), ecf_id, liyuanDate FROM hl_orbit_ecf_result GROUP BY liyuanDate HAVING count( liyuanDate )> 1 ) a # 中间表
)
AND ecf_id NOT IN (
SELECT
b.ecf_id #保留的一条数据的 条件
FROM
( SELECT count( liyuanDate ), ecf_id, liyuanDate FROM hl_orbit_ecf_result GROUP BY liyuanDate HAVING count( liyuanDate )> 1 ) b #中间表
)
SQL语句 删除重复数据,并且只保留一条
最新推荐文章于 2023-08-23 19:24:10 发布