Skip to content

Instantly share code, notes, and snippets.

@Osiyuks

Osiyuks/EXCEPT DISTINCT for testing tables

Created July 16, 2020 15:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Osiyuks/80d41f4390802af422f70a99b28ca749 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Osiyuks/80d41f4390802af422f70a99b28ca749 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
EXCEPT DISTINCT for testing tables
SELECT * FROM UNNEST(ARRAY<int64>[1, 2, 3, 4, 5])
EXCEPT DISTINCT -- INTERSECT DISTINCT
SELECT * FROM UNNEST(ARRAY<int64>[3, 4, 5, 6, 7])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment