Form:data
Time Amount
2015-01-01 10000
2015-01-02 20000
2015-01-03 30000
select a.时间,sum(b .Amount) as Cumulative amount
from data a,data b
< p>where a. time>=b. time
group by a. time
SQLite achieve time accumulation
WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 882 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC