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/11/21 20:11:42

SELECTCASEABC.AWHEN''否''THEN''1''WHEN''是''THEN''-1''ENDAS出入标识,ABC.BAS数量,这两个字段相乘?SELECTCASEABC.AWHEN''否''THEN''1

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
)

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 语句里可以再套select case vb select case 这个语句? VBA Str$=“Upper Case”难不成是定义一个变量Str是字符串型的?Upper “把谁转换成大写?Select Case a$Case A To ZStr$=Upper CaseCase a To zStr$=Lower CaseCase 0 To 9Str$=NumberCase ,,,,.,;Str$=Punctuato select case 语句怎么判断在某两个值之间如题我要把 if a> 3 and a =5 and a 16 and a = 85 Grade = 优秀 Case Is > = 75 Grade = 良好 Case Is > = 70 Grade = 中等 Case Is > = 60 Grade = 及格 end Select 有错误,在vb select a house,andthen selectupgrade. case when then else end 能用在条件判断上么比如select * from app a where --在这加case when 可以么?select * from app a where case when a.id = 1 then a.name = '22' else a.name = '33' select case x结构中,描述判断条件3 select a versino,piease! Select a username是什么意思 to select a Select a country是什么意思 Select a password是什么意思? 这段文字的意思update student　　set grade = (　　select grade from　　(　　select id,　　case when score> 90 then 'a'　　when score > 80 then 'b'　　when score > 70 then 'c'　　else 'd' end grade　　from student　　) a SELECT Please select a language first. select a Number 谁知道啊 Please select a valid date.