这语句为什么会出错呢？

[LJDargon]

select case  when count(*)=0 then 0 else score end from (select top 1 score  from ZX_RESULT_INDEXSYSTEM 
where companyCode = '20161017' 
and indexCode = '201609261811' 
and datepart(month,inspectDate)=10
and datepart(year,inspectDate)=2016
order by inspectDate desc) t

[巨巨巨]

引用 楼主 LJDargon 的回复:

select case  when count(*)=0 then 0 else score end from (select top 1 score  from ZX_RESULT_INDEXSYSTEM 
where companyCode = '20161017' 
and indexCode = '201609261811' 
and datepart(month,inspectDate)=10
and datepart(year,inspectDate)=2016
order by inspectDate desc) t

你应该这样写： [code=sql][/ select isnull((select top 1 score from ZX_RESULT_INDEXSYSTEM where companyCode = '20161017' and indexCode = '201609261811' and datepart(month,inspectDate)=10 and datepart(year,inspectDate)=2016 order by inspectDate desc),0) code]

[中国风]

SELECT  ISNULL(MAX(score), 0)
FROM    ( SELECT TOP 1
                    score
          FROM      ZX_RESULT_INDEXSYSTEM
          WHERE     companyCode = '20161017'
                    AND indexCode = '201609261811'
                    AND DATEPART(MONTH, inspectDate) = 10
                    AND DATEPART(YEAR, inspectDate) = 2016
          ORDER BY  inspectDate DESC
        ) t;