案例陈述 [英] case statement

问题描述

未按预期获得结果 

not getting the result as expected 

当Qualified = 2时，它应该为1，Level1BonusQualified，以及Level12BonusQualified，以防它应该1为所有级别 

when Qualified = 2 it should 1 for Level1BonusQualified, and Level12BonusQualified, in case it should 1 be for all levels 

推荐答案

您的代码有点混乱。



为每个列别名做一行代码如下：



符合条件的情况= 1 那么'1'当合格= 2那么'2'''3'结束为Level1BonusQualified，

情况当合格= 2 那么'1'当合格= 1然后'2'''3'结束为  Level2BonusQualified，

Your code is a bit confuse.

Do an line for each column alias like:

CASE WHEN Qualified = 1  THEN '1' WHEN Qualified = 2 THEN '2' ELSE '3' END AS Level1BonusQualified,
CASE WHEN Qualified = 2  THEN '1' WHEN Qualified = 1 THEN '2' ELSE '3' END AS  Level2BonusQualified,

这篇关于案例陈述的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！