sql case when 老是语法报错,请问语法哪错了?

来源：学生作业帮编辑：拍题作业网作业帮分类：综合作业时间：2024/05/15 01:16:55

sql case when 老是语法报错,请问语法哪错了?
SELECT zhu.mingzi,zhu.riqi,zhu.liucheng,zhu.xinghao,zhu.shuliang,
case
when [liucheng] = '点装' then '1'
when [liucheng] = '装脚' then '2'
when [liucheng] = '只装' then '3'
when [liucheng] = '点胶' then '4'
when [liucheng] = '切腿' then '5'
when [liucheng] = '电测' then '6'
when [liucheng] = '全检' then '7'
else '8' end AS dj
[shuliang]*[danjia] AS zongjia
FROM danjia,zhu;

access 没有case 语句的,你可以用iif 来实现
SELECT zhu.mingzi, zhu.riqi, zhu.liucheng, zhu.xinghao, zhu.shuliang,
iif(liucheng = '点装',1,
iif(liucheng = '装脚',2,
iif(liucheng = '只装',3,
iif(liucheng = '只装',4,
iif(liucheng = '只装',5,
iif(liucheng = '只装',6,
iif(liucheng = '只装',7,8)
)))))) as dj
[shuliang]*[danjia] AS zongjia
FROM danjia, zhu

sql case when 老是语法报错,请问语法哪错了? 下面的SQL语法哪里错了?怎样改正? SQL语句case when sql case when请教 sql语句 case when or 请问这两道英语选择题是考察哪部分语法知识的?总是错,想复习一下语法点了. sql case when then ...虚心求教 sat 语法题. 请问e错在哪里了? Sat 语法题请问e怎么错了 DB2 执行Alter语句报错,请问什么原因?SQL State ：54010 when have you been there?这句话语法哪里错了? MATLAB 程序老是报错,