DELETE FROM snwit_trading_table
WHERE 1=1
AND trading_hash
in (SELECT * FROM ( (SELECT trading_hash
trading_hashs
FROM snwit_trading_table GROUP BY trading_hash HAVING COUNT(trading_hash
)>1) ) a)
AND id not in (SELECT * FROM ( (SELECT max(id) ids FROM snwit_trading_table GROUP BY trading_hash HAVING COUNT(trading_hash
)>1) ) b)
sql删除重复数据只保留一条数据
最新推荐文章于 2024-07-11 10:27:20 发布