HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

Generate series 0.01 to 0.99

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
seriesgeneratestackoverflow

Problem

Is there any simple method to get a series:
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 :

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 series


0.01 - increment value from series start to series end

Code 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 series
0.01 - increment value from series start to series end

Context

StackExchange Database Administrators Q#298996, answer score: 4

Revisions (0)

No revisions yet.