Breaking News: Grepper is joining You.com. Read the official announcement!

sql compare two tables for differences

Joyous Jaguar answered on May 16, 2022 Popularity 10/10 Helpfulness 5/10

answer sql compare two tables for differences

related how to compare two table data in sql

sql compare two tables for differences

Comment

--SI vous avez des tables Aet B, 
--toutes deux avec colum C, voici les enregistrements, 
--qui sont présents dans table Amais pas dans B:

SELECT A.*
FROM A
    LEFT JOIN B ON (A.C = B.C)
WHERE B.C IS NULL

--Pour obtenir toutes les différences 
--avec une seule requête, 
--une jointure complète doit être utilisée, comme ceci :

SELECT A.*, B.*
FROM A
    FULL JOIN B ON (A.C = B.C)
WHERE A.C IS NULL OR B.C IS NULL

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: compare sql

Link to this answer
Share Copy Link

Contributed on May 16 2022

Joyous Jaguar

0 Answers Avg Quality 2/10

Closely Related Answers

how to compare two table data in sql

Comment

Select domain From table_one A 
Where NOT EXISTS 
( select 1 from table_two B where A.domain= B.domain );

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: compare

Link to this answer
Share Copy Link

Contributed on Mar 16 2023

Indonesia People

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

sql compare two tables for differences

Contents

More Related Answers

sql compare two tables for differences

Closely Related Answers

how to compare two table data in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.