Delete Duplicates

without using rowid:

DELETE FROM TBL_E_ISSUES a
WHERE a.REC_ID != (SELECT MAX(b.REC_ID)
FROM TBL_E_ISSUES b
WHERE a.ORDER_ID = b.ORDER_ID);

using rowid:

DELETE FROM TBL_E_ISSUES L1
WHERE L1.ROWID < ANY (SELECT L2.ROWID FROM TBL_E_ISSUES L2 WHERE
L2.order_id = L1.order_id);