查询结果
查询语句
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; select tDailyCount.ddate, tDailyCount.cou
