【sqlcasewhen老是语法报错,请问语法哪错了?SELECTzhu.mingzi,zhu.riqi,zhu.liucheng,zhu.xinghao,zhu.shuliang,casewhen[liucheng]='点装'then'1'when[liucheng]='装脚'then'2'when[liucheng]='只装'then'3'when[liucheng]='】
更新时间： 2025-08-29 04:40:57
1人问答
问题描述：
sqlcasewhen老是语法报错,请问语法哪错了?
SELECTzhu.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'endASdj
[shuliang]*[danjia]ASzongjia
FROMdanjia,zhu;
刘建荣回答：
access没有case语句的,你可以用iif来实现
SELECTzhu.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)
))))))asdj
[shuliang]*[danjia]ASzongjia
FROMdanjia,zhu
其它推荐
其它推荐
最新更新
精品分类
优秀其它推荐
热门其它