-- 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>;
select * from tableA minus select * from tableB