查找重复数据
SELECT * FROM b_spjk_spfzmx WHERE spsbbh IN
(SELECT spsbbh FROM b_spjk_spfzmx GROUP BY spsbbh HAVING COUNT (spsbbh) > 1) ORDER BY spsbbh ASC
删除重复数据
DELETE FROM b_spjk_spfzmx WHERE spsbbh IN
(SELECT spsbbh FROM b_spjk_spfzmx GROUP BY spsbbh HAVIN COUNT (spsbbh) > 1 )
AND
xh NOT IN
(SELECT MIN (xh) FROM b_spjk_spfzmx GROUP BY spsbbh HAVING COUNT (spsbbh) > 1
Postgres操作之重复数据
最新推荐文章于 2023-07-15 11:19:18 发布