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

Tags:

Sql Example