Answers for "how to find data with discrepancy in sql server"

SQL
3

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>;
Posted by: Guest on May-20-2020
1

sql compare data from two tables

select * from tableA
minus
select * from tableB
Posted by: Guest on September-27-2020

Code answers related to "how to find data with discrepancy in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language