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为什么总说有不能识别的短语或关键字

来源:学生作业帮助网 编辑:六六作业网 时间:2024/05/09 21:37:17
select*top99percentfrom职工orderbycasewhen工资isnullthen1else0end哪里出错了select*top99percentfrom职工orderbyca

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为什么总说有不能识别的短语或关键字
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
为什么总说有不能识别的短语或关键字

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为什么总说有不能识别的短语或关键字
case when 是不是应该写在select 里的啊?order by 排序 至少也要用括号括起来.