56,687
社区成员
发帖
与我相关
我的任务
分享
select t1.group1,t1.cdate AS date_time,(t1.ovalue-t2.ovalue) AS cha_value
from (
Select group1,date(date_time) as cdate,sum(obj_value) as ovalue
from t_201012 a
where not Exists (select 1 from t_201012 where group1=a.group1 And date(date_time)=date(a.date_time) and date_time>a.date_time)
group by group1,date(date_time)
) t1 left join (
select group1,DATE(date_time) as cdate,sum(obj_value) as ovalue
from t_201012 a
where Not exists (select 1 from t_201012 where group1=a.group1 And date(date_time)=date(a.date_time) and date_time>a.date_time)
group by group1,date(date_time)
) t2 on (t1.group1=t2.group1 and t1.cdate=t2.cdate+interval 1 day)
order by 2