在sql server 查询分析器里执行它有错误：
select sum(case num1=2 then 1 else 0 end) as tt from test
提示错误：
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='.


大家知道是什么问题吗，在线等
谢谢

select sum(if num1=2 then 1 else 0 end) as tt  from test

还是不行，提示错误：
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'if'.
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'then'.

都是sql 语法错误，建议仔细参考一下 sum用法

select sum( case num1
when 2 then 1
else 0
end ) as tt from test

谢谢各位了，解决了