SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,这两个字段相乘?SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,我想让这个两个相乘,即出入标识*
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 16:22:20
![SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,这两个字段相乘?SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,我想让这个两个相乘,即出入标识*](/uploads/image/z/6836067-27-7.jpg?t=SELECT+CASE+ABC.A+WHEN%27%E5%90%A6%27+THEN%271%27+WHEN%27%E6%98%AF%27+THEN%27-1%27+END+AS+%E5%87%BA%E5%85%A5%E6%A0%87%E8%AF%86%2CABC.B+AS+%E6%95%B0%E9%87%8F%2C%E8%BF%99%E4%B8%A4%E4%B8%AA%E5%AD%97%E6%AE%B5%E7%9B%B8%E4%B9%98%3FSELECT+CASE+ABC.A+WHEN%27%E5%90%A6%27+THEN%271%27+WHEN%27%E6%98%AF%27+THEN%27-1%27+END+AS+%E5%87%BA%E5%85%A5%E6%A0%87%E8%AF%86%2CABC.B+AS+%E6%95%B0%E9%87%8F%2C%E6%88%91%E6%83%B3%E8%AE%A9%E8%BF%99%E4%B8%AA%E4%B8%A4%E4%B8%AA%E7%9B%B8%E4%B9%98%2C%E5%8D%B3%E5%87%BA%E5%85%A5%E6%A0%87%E8%AF%86%2A)
SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,这两个字段相乘?SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,我想让这个两个相乘,即出入标识*
SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,这两个字段相乘?
SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,我想让这个两个相乘,即出入标识*数量,我这样做的(CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END*ABC.B) AS 新数量,这样做语句是错误的,不知如何能让这两列相乘?
SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,这两个字段相乘?SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,我想让这个两个相乘,即出入标识*
CASE WHEN 语法不对吧
CASE WHEN ABC.A = '否' THEN '1'
WHEN ABC.A = '是' THEN '-1'
END AS 出入标识
两列相乘的话, 那么 THEN 里面, 就写 1, 别写 '1' 了.
然后外面再套一个查询
也就是
SELECT
出入标识 * 数量
FROM
(
SELECT . 你原有的SQL
)