I have a question regarding aggregation using group by. Assuming I have a below table
Code: Select all
start | end | value
1 | 2 | 10
2 | 4 | 6
4 | 5 | 4
5 | 8 | 8
8 | 10 | 5
Moderator: NorbertKrupa
Code: Select all
start | end | value
1 | 2 | 10
2 | 4 | 6
4 | 5 | 4
5 | 8 | 8
8 | 10 | 5
Code: Select all
kyle=> select * from kyle order by startTime;
startTime | endTime | value
-----------+---------+-------
1 | 2 | 10
2 | 4 | 6
4 | 5 | 4
5 | 8 | 8
8 | 10 | 5
(5 rows)
kyle=> select startTime, width_bucket(startTime, 0, 10, 2) from kyle order by startTime;
startTime | width_bucket
-----------+--------------
1 | 1
2 | 1
4 | 1
5 | 2
8 | 2
(5 rows)