SELECT CONVERT(nvarchar(10), CONVERT(nvarchar(50), Time, 120), 120) AS 时间, AVG(isnull(Rtd,0)) AS 实时值平均值, AVG(isnull([Avg],0)) AS 平均值, AVG(isnull([Min],0)) AS 最小值平均值, AVG(isnull([Max],0)) AS 最大值平均值, AVG(isnull(zsRtd,0)) AS 折算实时值平均值, AVG(isnull(zsMin,0)) AS 折算最小值平均值, AVG(isnull(zsAvg,0)) AS 折算平均值, AVG(isnull(zsMax,0)) AS 折算最大值平均值 FROM Data_Rtd_200901 WHERE (PluteId = 213) AND (CONVERT(nvarchar(50), Time, 120) > '20090104235959') AND (CONVERT(nvarchar(50), Time, 120) < '20090106000000') GROUP BY CONVERT(nvarchar(10), CONVERT(nvarchar(50), Time, 120), 120)
AVG(isnull(Rtd,0)) AS 实时值平均值,
AVG(isnull([Avg],0)) AS 平均值,
AVG(isnull([Min],0)) AS 最小值平均值,
AVG(isnull([Max],0)) AS 最大值平均值,
AVG(isnull(zsRtd,0)) AS 折算实时值平均值,
AVG(isnull(zsMin,0)) AS 折算最小值平均值,
AVG(isnull(zsAvg,0)) AS 折算平均值,
AVG(isnull(zsMax,0)) AS 折算最大值平均值
FROM Data_Rtd_200901
WHERE (PluteId = 213) AND (CONVERT(nvarchar(50), Time, 120) > '20090104235959') AND (CONVERT(nvarchar(50), Time, 120) < '20090106000000')
GROUP BY CONVERT(nvarchar(10), CONVERT(nvarchar(50), Time, 120), 120)
用isnull() 函数处理下吧