doryokujin doryokujin

## get_combination_all.sql
SELECT n1.number, n2.number
FROM
(
  SELECT number
  FROM numbers
) n1,
(
  SELECT number
  FROM numbers
) n2

## gist:1719faa5e69d0f41fed6
number number
1	1
1	2
1	3
1	4
1	5
1	6
2	1
2	2
2	3

## result_combination_all
number  number
1	1
1	2
1	3
1	4
1	5
1	6
2	1
2	2
2	3

## numbers
number
1
2
3
4
5
6

## get_combination_not-same.sql
SELECT n1.number, n2.number
FROM
(
  SELECT number
  FROM numbers
) n1,
(
  SELECT number
  FROM numbers
) n2

## get_combinaiton_not-same
number  number
1	2
1	3
1	4
1	5
1	6
2	1
2	3
2	4

## get_combination_no-order.sql
SELECT n1.number, n2.number
FROM
(
  SELECT number
  FROM numbers
) n1,
(
  SELECT number
  FROM numbers
) n2

## result_combination_no-order
number  number
1	2
1	3
1	4
1	5
1	6
2	3
2	4
2	5
2	6

## men_&_women
id,gender
m1,man
m2,man
w1,woman
w2,woman
w3,woman

## get_matching_mistake.sql
SELECT n1.id, n2.id, n1.id || ' ♥ ' || n2.id
FROM
(
  SELECT id, gender
  FROM men_and_women
) n1,
(
  SELECT id, gender
  FROM men_and_women
) n2
	SELECT n1.number, n2.number
	FROM
	(
	SELECT number
	FROM numbers
	) n1,
	(
	SELECT number
	FROM numbers
	) n2
	SELECT n1.id, n2.id, n1.id \|\| ' ♥ ' \|\| n2.id
	FROM
	(
	SELECT id, gender
	FROM men_and_women
	) n1,
	(
	SELECT id, gender
	FROM men_and_women
	) n2