数据库去重留一

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

DELETE FROM TB_COMPLAINTS_G_3
WHERE (流水号) IN
      (SELECT 流水号 FROM TB_COMPLAINTS_G_3 WHERE STATIS_MONTH BETWEEN 201702 and 201704 GROUP BY 流水号 HAVING COUNT(流水号) > 1)
AND
ROWID NOT IN
      (SELECT MIN(ROWID) FROM TB_COMPLAINTS_G_3  WHERE STATIS_MONTH BETWEEN 201702 and 201704 GROUP BY 流水号 HAVING COUNT(*) > 1);
COMMIT;

在以前的数据库，这条语句是可以使用的。因为要换服务器，所以新建了一个数据库，而且按照老数据库创建了一些表，把数据都录进去了，但是使用这天去重语句时就一直执行，没有报错。没有锁表。求大神帮帮忙！！

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：数据库 Between having Statis Select

DELETE FROM TB_COMPLAINTS_G_3
WHERE 流水号 IN
      (SELECT 流水号 FROM TB_COMPLAINTS_G_3 WHERE STATIS_MONTH BETWEEN 201702 and 201704 GROUP BY 流水号 HAVING COUNT(流水号) > 1)
AND
ROWID NOT IN
      (SELECT MIN(ROWID) FROM TB_COMPLAINTS_G_3  WHERE STATIS_MONTH BETWEEN 201702 and 201704 GROUP BY 流水号 HAVING COUNT(流水号) > 1);

DELETE FROM TB_COMPLAINTS_G_3
WHERE 流水号 IN (SELECT 流水号 FROM TB_COMPLAINTS_G_3 WHERE STATIS_MONTH BETWEEN 201702 and 201704 GROUP BY 流水号 HAVING COUNT(流水号) > 1)
AND ROWID NOT IN (SELECT MIN(ROWID) FROM TB_COMPLAINTS_G_3  WHERE STATIS_MONTH BETWEEN 201702 and 201704 GROUP BY 流水号 HAVING COUNT(流水号) > 1);