22,209
社区成员
发帖
与我相关
我的任务
分享
select stationName,obsTime as obsmonth,max(B.T) as maxT,max(mastTtime) as maxTtime,max(RH) as minRH,max(minRHtime) AS minRHtime,sum(Rain) as sumrain
from
(select A.stationName,convert(varchar(7),A.obsTime,120) as obsTime,Rain,B.T,B.obsTime as mastTtime,C.RH,C.obsTime as minRHtime
from t_data A
outer apply (select top 1 T,obsTime from t_data where A.stationName=stationName and convert(varchar(7),A.obsTime,120)=convert(varchar(7),obsTime,120) order by T desc) as B
outer apply (select top 1 RH,obsTime from t_data where A.stationName=stationName and convert(varchar(7),A.obsTime,120)=convert(varchar(7),obsTime,120) order by RH) as C) as A
group by stationName,obsTime