MINUS

The MINUS set operator shows the rows that are present in the first query but absent in the second in ascending order, removing any duplicate rows.

So, for example, if we want to get the entries from Table1, but leave out those entries that are also present in Table2, we’d run the following query:

1SELECT * FROM Table1
2MINUS
3SELECT * FROM Table2;

Then, the resulting table would look like this:

As we can see, the resulting table is the same as Table1, only without the customers with IDs 2 and 3, which are the ones that are present in Table2 as well.