Skip to content

Instantly share code, notes, and snippets.

@exalted

exalted/sql-cheatsheet.txt

Last active July 9, 2018 02:02
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save exalted/019fa55faa521c58fc85 to your computer and use it in GitHub Desktop.
Save exalted/019fa55faa521c58fc85 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Cheatsheet
Raw
sql-cheatsheet.txt
+--------------------------------------------------------------------+
| |
| SELECT * |
| FROM A |
| [INNER] JOIN B ON A."FOO" = B."BAR" [AND ...]; |
| |
+--------------------------------------------------------------------+
| |
| SELECT * |
| FROM A |
| <LEFT|RIGHT|FULL> [OUTER] JOIN B ON A."FOO" = B."BAR" [AND ...]; |
| |
+--------------------------------------------------------------------+
| |
| SELECT * SELECT * |
| FROM A <=> FROM A, B; |
| CROSS JOIN B |
| |
+--------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment