Question

我对 MySQL 添加三个值有问题, 这应该很简单吧?

我有代码,根据第二列的值从一列中选择数值,我使用这样一个案例的语句:

Select
        Max(Case
            When Table1.costcode Like  %Costcode1%  
            Then Table1.costs 
            Else Null End) As  Costcode1 ,
        Max(Case
            When Table1.costcode Like  %Costcode2%  
            Then Table1.costs
            Else Null End) As  Costcode2 ,
        Max(Case
            When Table1.costcode Like  %Costcode3%  
            Then Table1.costs 
            Else Null End) As  Costcode3 ,
        (Case
            When Table1.costcode In ( %Costcode1% , %Costcode2% , %Costcode3% )
            Then Sum(Table1.costs)
            Else Null End) As  Total Cost ,

From Table1

前三个案件报表运作良好,所有回报值(在数据库中保存为负数,例如-13624.00),但总成本案例只返回Null...

表1. 成本代码栏中包括许多其他代码,所以我无法在不先选取这些代码的情况下,对所有数值进行总和。

但显然我遗漏了一些东西...

谢谢谢谢

Answer 1

试试这个

    SUM(Case Table1.costcode
        When LIKE ( %Costcode1% ) Then Table1.costs
        When LIKE ( %Costcode2% ) Then Table1.costs
        When LIKE ( %Costcode3% ) Then Table1.costs
        Then Table1.costs
        Else 0.00 End) As  Total Cost

友情链接