Before deleting any data in table it always Best Practice to take
back up
So
here is the Sample SQL
Creating a Temp Table
CREATE
TABLE SYSADM.PS_PO_HDR_TMP AS SELECT * FROM SYSADM.PS_PO_HDR WHERE
BUSINESS_UNIT = 'MN300';
Make sure Table is created with Expected rows of data
SELECT *
FROM SYSADM.PS_PO_HDR_TMP;
Delete rows from main table to remove data of backup data
DELETE
FROM SYSADM.PS_PO_HDR
WHERE
(BUSINESS_UNIT,PO_ID) IN (SELECT
BUSINESS_UNIT,PO_ID FROM SYSADM.PS_PO_HDR_TMP);
No comments:
Post a Comment