0
Hello, I wonder if you could return only the averages per hour of a table as below:
id | valor | timestamp |
1 | 5.4 | 2017-4-20 18:00 |
2 | 3 | 2017-4-20 18:01 |
3 | 2.8 | 2017-4-20 18:40 |
4 | 2 | 2017-4-20 19:00 |
5 | 10 | 2017-4-20 19:05 |
6 | 7 | 2017-4-20 19:20 |
7 | 1 | 2017-4-20 19:55 |
8 | 5 | 2017-4-20 20:00 |
9 | 7 | 2017-4-20 20:11 |
10 | 4 | 2017-4-20 20:50 |
11 | 6 | 2017-4-20 21:00 |
------------------------------
..would have any select to return the hourly averages from the "value" column? I am trying but unsuccessfully...
Yes, it’s in my answer
– user60252