Hi All,
I am using MINUS operator to fetch the records that don't match in two tables actual and backup table.
Select * from Table_BKP
MINUS
Select * from Table_Actual;
The above query shows both the records, the records that was updated to Table_Actual, and records that was deleted from Table_Actual.
I want only deleted records to display, is it possible ? Please help to provide the SQL. Thanks in advance.