Need a query for accumulated values

0 votes

1 answer

162 views

                          I need query for accumulated values from particular column with specific time interval.  

    time         |      value  
    --------------------------  
    2020-02-26 09:30:00 |  5  
    2020-02-26 09:31:00 |  3  
    2020-02-26 09:32:00 |  4  
    2020-02-26 09:33:00 |  5  
    2020-02-26 10:31:00 |  5  
    2020-02-26 10:32:00 |  2  
    2020-02-26 10:34:00 |  4  
    2020-02-26 10:36:00 |  6  

Fetch the data from table interval wise(15m,1hour,1 day) & calculate the max value and finally calculated the accumulated(1,2,3 values should be 1,3,6).

For Ex : 1hour interval then the result was:  

    time         |      value  
    --------------------------  
    2020-02-26 09:00:00 |  5   
    2020-02-26 10:00:00 |  6  
    
and accumulated result was:

    time         |      value  
    --------------------------  
    2020-02-26 09:00:00 |  5   
    2020-02-26 10:00:00 |  11

Asked by Avz Vicky (1 rep)

Feb 26, 2020, 11:49 AM
Last activity: Jul 12, 2025, 05:05 PM

Need a query for accumulated values

Related Questions