Here is the final query I have used with a small modification with yours since I have hourly data. Once again, Thank You very much.

SELECT

SD.ID

...

Hello Smendle,

Thank you very much for the reply. I have gone through the link posted. I will make sure to follow those steps for any further help.

Regards,

Venkat

Dear Eirikur Eiriksson,

Thank you very much. The query example you have given worked.

Thank you very much for the reply. It works to check if there is rain in that hour. However, i also need to check previous 2 hours for each ID.