Skip to content

Instantly share code, notes, and snippets.

@larsar

larsar/query_diff.sql

Last active April 8, 2022 10:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save larsar/77499ce5772b93ef09303ef37699739e to your computer and use it in GitHub Desktop.
Save larsar/77499ce5772b93ef09303ef37699739e to your computer and use it in GitHub Desktop.
Download ZIP
Diff result from two different SQL queries
Raw
query_diff.sql
WITH query1 AS (SELECT * FROM ...),
query2 AS (SELECT * FROM ...),
in_query1 AS (SELECT * FROM query1 EXCEPT SELECT * FROM query2),
in_query2 AS (SELECT * FROM query2 EXCEPT SELECT * FROM query1)
SELECT 'query1' AS query, *
FROM in_query1
UNION ALL
SELECT 'query2' AS query, *
FROM in_query2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment