Sql compare data from two tables

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

This article is tagged with: Sql compare data from two tables and mysql