SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:综合作业 时间:2024/05/13 08:55:52
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 数量,我想让这个两个相乘,即出入标识*数量,我这样做的(CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END*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
)
CASE WHEN ABC.A = '否' THEN '1'
WHEN ABC.A = '是' THEN '-1'
END AS 出入标识
两列相乘的话, 那么 THEN 里面, 就写 1, 别写 '1' 了.
然后外面再套一个查询
也就是
SELECT
出入标识 * 数量
FROM
(
SELECT . 你原有的SQL
)
SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入
select CNAME=case when CNAME is null then '4' else '1' end f
(case A.ZT when 1 then 's318' else null end)
CASE a WHEN 1 THEN b ELSE NULL END
case when.then.else.end
case when then else end
PLSQL中,select case..when..then..怎么用?
--简单Case函数 CASE sex WHEN '1' THEN '男' WHEN '2' THEN '女' ELSE
sql case when then ...虚心求教
c#开发cast( (case when b.pbproject_ID is null then 1 else 0 en
A.then B.as C.than D.when
英语翻译afterwards,in the end,one day,suddently,then,when(1)( )i