- Joined
- May 20, 2008
- Messages
- 6
- Reaction score
- 0
I need some direction on group by
I have a table that tracks wind speed and barometric pressure by latitude and longitude and date (month,day, year). I'm trying to figure out how to write a sql statement that will find the maximum wind speed across all years for each 10 degrees of latitude. I was thinking I could use group by but not sure how to find by 10.
For example - I need to find the maximum wind speed for latitude between 0 - 10, 11 - 29, 30 - 39, etc up to 90.
Any direction will be appreciated
I have a table that tracks wind speed and barometric pressure by latitude and longitude and date (month,day, year). I'm trying to figure out how to write a sql statement that will find the maximum wind speed across all years for each 10 degrees of latitude. I was thinking I could use group by but not sure how to find by 10.
For example - I need to find the maximum wind speed for latitude between 0 - 10, 11 - 29, 30 - 39, etc up to 90.
Any direction will be appreciated
Last edited: