faire la différence entre deux tables sql big query

Puzzled Porpoise answered on April 25, 2022 Popularity 1/10 Helpfulness 3/10

answer faire la différence entre deux tables sql big query

Comment

(
  SELECT * FROM table1
  EXCEPT DISTINCT
  SELECT * from table2
)

UNION ALL

(
  SELECT * FROM table2
  EXCEPT DISTINCT
  SELECT * from table1
)

Popularity 1/10 Helpfulness 3/10 Language sql

Tags: difference sql

Link to this answer
Share Copy Link

Contributed on Apr 25 2022

Puzzled Porpoise

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.

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