SQL Query

T

Techsavy

Guppy
Hello,

I am trying to analyze 56 years of hourly rainfall data.

Right now i have three columns. Date(mm/dd/yyyy), hr(0-23) and hourly Rainfall(inches).

I would like to know the count of rainfall events that exceed 2.4 inches in 24 hrs.

once an event is identified the next event should be identified with a gap of 72 hours.

Any suggestions on how to query this?

Thanks,
 
Hey TechSavy,

How about something like the following:

SELECT Date,SUM(Rainfall) FROM table
GROUP BY Date
HAVING SUM(Rainfall)>2.4
 
You must log in or register to reply here.
Back
Top