select * top 99 percent from 职工 order by case when 工资 is null then 1 else 0 end 哪里出错了select * top 99 percent from 职工 order by case when 工资 is null then 1 else 0 end为什么总说有不能识别的短语或关键字

Question

select * top 99 percent from 职工 order by case when 工资 is null then 1 else 0 end 哪里出错了
select * top 99 percent from 职工 order by case when 工资 is null then 1 else 0 end
为什么总说有不能识别的短语或关键字

Answer 1

case when 是不是应该写在select 里的啊?order by 排序 至少也要用括号括起来.