-- Temprary Table の作成 --
WITH numbers AS  (SELECT * FROM (VALUES 1,2,3,4,5,6) AS t(number))
-- 以下，temporary table: numbers を用いてのクエリ --
SELECT n1.number, n2.number
FROM
(
  SELECT number
  FROM numbers
) n1,
(
  SELECT number
  FROM numbers
) n2
ORDER BY n1.number, n2.number