select convert(varchar(13),riqi,120) as rq,avg(a),avg(a),avg(a) from tb where ff=1 group by convert(varchar(13),riqi,120) union select convert(varchar(13),riqi,120) as rq,avg(a),avg(a),avg(a) from tb a where not exsits (select 1 from tb where convert(varchar(13),riqi,120)=convert(varchar(13),a.riqi,120) and ff=1)
整个小时内a,b,c的平均值?
和解?
select convert(varchar(13),riqi,120) as rq,avg(a),avg(a),avg(a)
from tb where ff=1 group by convert(varchar(13),riqi,120)
union
select convert(varchar(13),riqi,120) as rq,avg(a),avg(a),avg(a)
from tb a where not exsits
(select 1 from tb
where convert(varchar(13),riqi,120)=convert(varchar(13),a.riqi,120)
and ff=1)