Skip to content

Instantly share code, notes, and snippets.

@AlphaWong

AlphaWong/UNION.sql

Created July 26, 2017 07:55
Show Gist options
  • Save AlphaWong/49a776a422473dc51c289436023e72ef to your computer and use it in GitHub Desktop.
Save AlphaWong/49a776a422473dc51c289436023e72ef to your computer and use it in GitHub Desktop.
Download ZIP
sql leaning
Raw
UNION.sql
# OR statment
SELECT * FROM TABLE 1 WHERE col1 = 1 OR col1 = 2
# UNION ALL
SELECT * FROM TABLE 1 WHERE col1 = 1
UNION ALL
SELECT * FROM TABLE 1 WHERE col1 = 2
# Reference
# https://www.w3schools.com/sql/sql_union.asp
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment