difference between two tables in sql code example
Example 1: sql difference between tables
-- Oracle
-- Example
SELECT *
FROM Table1 -- the table containing extra records
MINUS
SELECT *
FROM Table2;
-- Syntax
SELECT *
FROM <table-1> -- the table containing extra records
MINUS
SELECT *
FROM <table-2>;
Example 2: sql compare data from two tables
select * from tableA
minus
select * from tableB
Example 3: how to make sure two tables have same exact data in sql
Table1 MINUS Table2 ->> 0 Row && Table2 MINUS Table1 ->>0 Row