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