在Case语句中使用别名

Question

我想把这个案子化名为Brutobedrag，但我做不到。

SELECT     
    Invoices.InvoiceNr AS Factuurnummer, 
    case(Invoices.IsDebit)
        when 0 then -1*(Invoices.NetAmount + Invoices.BTW + COALESCE (Invoices.BPM, 0)) 
        else Invoices.NetAmount + Invoices.BTW + COALESCE (Invoices.BPM, 0)
    end 
from
    Brands INNER JOIN
    Invoices ON Brands.Id = Invoices.Brand INNER JOIN
    SalesPersons ON Invoices.SalesPerson = SalesPersons.Id LEFT OUTER JOIN
    Payments ON Invoices.Id = Payments.InvoiceId

where
    Invoices.InvoiceDate > '2011-12-31'

group by
    Invoices.InvoiceNr,
    Invoices.NetAmount,
    invoices.BTW,
    invoices.BPM,
    Invoices.IsDebit

Answer 1

case when Invoices.IsDebit = 0 
     then -1*(Invoices.NetAmount + Invoices.BTW + COALESCE (Invoices.BPM, 0)) 
     else Invoices.NetAmount + Invoices.BTW + COALESCE (Invoices.BPM, 0)
end as Brutobedrag 

Answer 2

当它的'BC‘

选择“BC”(“BC”时为“BC”，“AC”为1，“AC”为“4”，“CL”则为“3”“结束”)(选择“BC”时选择“BC”，“BC”则为“2 UNION”) UNION (选择'BC‘时为'BC’然后‘22’结束)联合(选择'BC‘时为'BC’，然后为‘BC’则为‘24’结束)UNION (选择“BC”时选择“BC”，然后选择“其他5”结尾)

答复:1 2 5 22 24

它将用于获得具有单一条件的多个值，以防发生