select
any_value(right (THOUR,2)) AS TIME_T
,any_value(left(ID_time,10)) as ID_time
,any_value(sum(Value_03)) as Value_03
,any_value(avg(Value_01)) as Value_01
,any_value(avg(Value_02)) as Value_02
,any_value(avg(Value_04)) as Value_04
,any_value(avg(Value_05)) as Value_05
,any_value(avg(Value_06)) as Value_06
,any_value(avg(Value_07)) as Value_07
,any_value(avg(Value_08)) as Value_08
,any_value(avg(Value_09)) as Value_09
,any_value(avg(Value_10)) as Value_10
,any_value(avg(Value_11)) as Value_11
,any_value(avg(Value_12)) as Value_12
from DWD_ORG_HOUR_AVG_HG
WHERE 1=1
<shebei> and Dev_Name IN (?{shebei})</shebei>
<start01> and DATE_FORMAT(ID_time,'%Y-%m-%d')=DATE_FORMAT(?{start01},'%Y-%m-%d')</start01>
group by TIME_T
|