本文主要是介绍MySQL 截至每天累计数据统计,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
查询结果
查询语句
select tDailyCount.ddate, tDailyCount.count, @dailycount := @dailycount + tDailyCount.count as scount from (select tTable.dd as ddate,count(*) as count from (SELECT jira_key, min(date_format(time, '%Y-%m-%d')) as dd FROM sonic.result_summary group by jira_key) as tTable group by ddate) as tDailyCount, (select @dailycount := 0) AS tTemp;
这篇关于MySQL 截至每天累计数据统计的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!