Re: Group by a range of values

On Sat, Aug 1, 2020 at 5:15 AM Mike Martin <redtux1(at)gmail(dot)com> wrote:

> Say I have a field of ints, as for example created by with ordinality or
> generate_series, is it possible to group by a range? eq
>
> 1,2,3,4,5,6,7,8,9,10
> step 3
> so output is
>
> 1 1
> 2 1
> 3 1
> 4 2
> 5 2
> 6 2
> 7 3
> 8 3
> 9 3
> 10 4
>
> thanks
>

*My solution would be:*
select num, ceiling(CAST (num as float)/3) as grp from Agg

*Yields:*
num grp
1 1
2 1
3 1
4 2
5 2
6 2
7 3
8 3
9 3
10 4

*For DDL of: *
CREATE TABLE Agg
("num" int);

INSERT INTO Agg
("num")
VALUES
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8),
(9),
(10);

I created this in SQL Fiddle: http://sqlfiddle.com/#!17/37519e/30/0