Answers for "sql table data compare"

SQL
4

sql compare tables

(SELECT * FROM T1 MINUS SELECT * FROM T2)   -- Rows that are in T1 but not in T2
UNION ALL
(SELECT * FROM T2 MINUS SELECT * FROM T1);  -- Rows that are in T2 but not in T1
Posted by: Guest on July-02-2021
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 "SQL"

Browse Popular Code Answers by Language