This article is tagged with:
Sql compare data from two tables
and mysql
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>;</table-2></table-1>
sql compare data from two tables
select * from tableA
minus
select * from tableB