Skip to content

Instantly share code, notes, and snippets.

@0rbadvent

0rbadvent/sql-cheatsheet.txt

Forked from exalted/sql-cheatsheet.txt
Created July 9, 2018 02:02
Show Gist options
  • Save 0rbadvent/20c21f41c54e62e563509877c218253e to your computer and use it in GitHub Desktop.
Save 0rbadvent/20c21f41c54e62e563509877c218253e 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