查询结果
查询语句
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;