SQL> select LAST_UPDATED_DATE, ODOMETER from demo; LAST_UPDA ODOMETER ——— ———- 05-OCT-18 47174.77 08-OCT-18 12-OCT-18 50246.37 15-OCT-18 19-OCT-18 53743.11 21-OCT-18 22-OCT-18 25-…
Tag: analytics
Query Oracle for 12 month moving total (SUM) of data
I need to run a query on some data that brings back the moving 12 month total. I’ve already performed the average function on the data… so now I just need to loop through and get a moving 12 month period of data and SUM it up so I can graph it. Below is the current query i’m issuing but