snippetsqlMinor
Generate series 0.01 to 0.99
Viewed 0 times
seriesgeneratestackoverflow
Problem
Is there any simple method to get a series:
like series generation from 1 to 99
0.01
0.02
0.03
...
...
...
0.97
0.98
0.99
like series generation from 1 to 99
SELECT * FROM generate_series(1, 99)Solution
Yes, it is quite easy:
Use :
Working demo: http://sqlfiddle.com/#!17/9eecb/80581
Use :
SELECT a.n
FROM generate_series(0.01, 0.99,0.01) as a(n);Working demo: http://sqlfiddle.com/#!17/9eecb/80581
0.01 - start of series
0.99 - end of series0.01 - increment value from series start to series endCode Snippets
SELECT a.n
FROM generate_series(0.01, 0.99,0.01) as a(n);0.01 - start of series
0.99 - end of series0.01 - increment value from series start to series endContext
StackExchange Database Administrators Q#298996, answer score: 4
Revisions (0)
No revisions yet.