巧用SQL實作連續編号

select id=a.id+b.id+c.id+d.id

from(

    select id=0 union all select 1

    union all select id=2 union all select 3

    union all select id=4 union all select 5

    union all select id=6 union all select 7

    union all select id=8 union all select 9

) a,(

    select id=0 union all select 10

    union all select id=20 union all select 30

    union all select id=40 union all select 50

    union all select id=60 union all select 70

    union all select id=80 union all select 90

) b,(

    select id=0 union all select 100

    union all select id=200 union all select 300

    union all select id=400 union all select 500

    union all select id=600 union all select 700

    union all select id=800 union all select 900

) c,(

    select id=0 union all select 1000

    union all select id=2000 union all select 3000

    union all select id=4000 union all select 5000

    union all select id=6000 union all select 7000

    union all select id=8000 union all select 9000

) d

order by id