使用case when 方法遇到判断空值时 使用 is null 但是报缺失表达式错误
select
case user_xmzt
when is null then ‘在建’
when ‘1’ then ‘执行’
when ‘2’ then ‘废弃’
when ‘3’ then ‘终止’
when ‘4’ then ‘完工未结算’
when ‘5’ then ‘结算未移交’
when ‘6’ then ‘关闭’
else ‘未知状态’
end
,count(user_xmzt) from project_table
group by user_xmzt
这是sql语句,始终发现不了错误在哪