Hello,
I have a query building a table named (idpap rus running rain), with columns id, yrdy, and ru_totalrain (the column to be summed, rainfall), please see the attachment.
Can someone suggest an faster query to calculate cumulative rainfall in 1, 2, 3, and 7 days in advance (or records in...