? SQL Server 2005 - group by

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
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top