case when 结果如何计算

Question

SELECT 
CASE
WHEN A<= 0 THEN
0
WHEN A>3THEN
5
ELSE
4,
FROM TA1这个CASE WHEN的结果 怎么能够*1.17？

Answer 1

在4后面还要加上 end *1.17

Answer 2

SELECT  CASE WHEN A <= 0 THEN 0
             WHEN A > 3 THEN 5
             ELSE 4
        END * 1.17
FROM    TA1;按条件加上A > 3才* 1.17SELECT  CASE WHEN A <= 0 THEN 0
             WHEN A > 3 THEN 5* 1.17
             ELSE 4
        END 
FROM    TA1;

Answer 3

SELECT 
（
CASE
WHEN A<= 0 THEN
0
WHEN A>3THEN
5
ELSE
4
END)*1.17 
FROM TA1