Skip to content

Instantly share code, notes, and snippets.

@frank-bg

frank-bg/0to1000000.sql

Created March 24, 2020 19:11
Show Gist options
  • Save frank-bg/f9ff25c8587ae80ad50ee900d6cbc4ae to your computer and use it in GitHub Desktop.
Save frank-bg/f9ff25c8587ae80ad50ee900d6cbc4ae to your computer and use it in GitHub Desktop.
Download ZIP
Raw
0to1000000.sql
CREATE TABLE del0al999999 AS
WITH d AS (
SELECT 0 d UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9
), del0al999999 AS (
SELECT
d0.d+(d1.d*10)+(d2.d*100)+(d3.d*1000)+(d4.d*10000)+(d5.d*100000) d
FROM d d0
CROSS JOIN d d1
CROSS JOIN d d2
CROSS JOIN d d3
CROSS JOIN d d4
CROSS JOIN d d5
)
SELECT * FROM del0al999999;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment