Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/combination_trump_all.sql

Created April 24, 2015 01:23
Show Gist options
  • Save doryokujin/303ab638ac194d0ebf18 to your computer and use it in GitHub Desktop.
Save doryokujin/303ab638ac194d0ebf18 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
combination_trump_all.sql
SELECT n1.number, n2.number, n1.symbol, n2.symbol
FROM
(
SELECT symbol,number
FROM trump
) n1,
(
SELECT symbol,number
FROM trump
) n2
ORDER BY n1.number, n2.number, n1.symbol, n2.symbol
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment