这几天在工作中遇到一个问题就是:要删除表在备份表中已存在的数据(2000多万数据),这个数据是SQL查出来的,例如:
select count(1)
from JY_SALE_FULLORDER_DTL
where LINE_NUM in (
select b.LINE_NUM
from JY_SALE_FULLORDER_DTL a join JY_SALE_FULLORDER_DTL_HIS B ON A.LINE_NUM = B.LINE_NUM
);
删除SQL:
DELETE FROM JY_SALE_FULLORDER_DTL
WHERE LINE_NUM IN (
SELECT b.LINE_NUM
FROM JY_SALE_FULLORDER_DTL a
JOIN JY