select
dbo.query_MCTD.stoptime
SUM(dbo.query_MCTD.ANS)
SUM(dbo.query_MCTD.ANS) / SUM(dbo.query_MCTD.NBR)
from query_MCTD
where SUM(dbo.query_MCTD.NBR) <> 0
group by dbo.query_MCTD.stoptime
dbo.query_MCTD.stoptime
SUM(dbo.query_MCTD.ANS)
SUM(dbo.query_MCTD.ANS) / SUM(dbo.query_MCTD.NBR)
from query_MCTD
where SUM(dbo.query_MCTD.NBR) <> 0
group by dbo.query_MCTD.stoptime
dbo.query_MCTD.stoptime
SUM(dbo.query_MCTD.ANS)
SUM(dbo.query_MCTD.ANS) / SUM(dbo.query_MCTD.NBR)
from query_MCTD
group by dbo.query_MCTD.stoptime
having sum(dbo.query_MCTD.NBR<>0
select dbo.query_MCTD.stoptime,SUM(dbo.query_MCTD.ANS)
SUM(dbo.query_MCTD.ANS) /
(case when SUM(dbo.query_MCTD.NBR)<>0 then SUM(dbo.query_MCTD.NBR)
else 1 end)
from query_MCTD
group by dbo.query_MCTD.stoptime
select dbo.query_MCTD.stoptime,SUM(dbo.query_MCTD.ANS)
SUM(dbo.query_MCTD.ANS) /
(case when SUM(dbo.query_MCTD.NBR)<>0 then SUM(dbo.query_MCTD.NBR)
else 1 end)
from query_MCTD
group by dbo.query_MCTD.stoptime
有出错信息,如下:
查询设计器不支持 CASE SQL 构造。