Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/get_combination_no-order.sql

Created April 23, 2015 02:46
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/90b2c8334fa47349ed38 to your computer and use it in GitHub Desktop.
Save doryokujin/90b2c8334fa47349ed38 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_combination_no-order.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