I have a large table which structure looks like that:
This is just to show you what I want to achieve, because my original table has nearly 1 million records.
Now imagine that I have temperature values calculated for every region which is represented by column geoid.
In this example I have 4 regions. For each region I have temperature values calculated 2 x daily for every day in a year.
What I need to get, is to calculate max temperature value for each day, thus in this example I need something which let me:
select first 8 rows -> calculate max temp. value for each geoid -> then select next 8 rows -> calculate max temp. value for new selection.
I need this to repeat for every day in a whole year.
How can I do this?