Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/get_combination_not-same.sql

Last active August 29, 2015 14:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doryokujin/a4ac361e23bc24cf4043 to your computer and use it in GitHub Desktop.
Save doryokujin/a4ac361e23bc24cf4043 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_combination_not-same.sql
SELECT n1.number, n2.number
FROM
(
SELECT number
FROM numbers
) n1,
(
SELECT number
FROM numbers
) n2
WHERE n1.number != n2.number
ORDER BY n1.number, n2.number
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment