sql - 如何在 SQL Server 的 View 中使用 else-if 条件？

Question

我知道可以使用 CASE 语句实现 if 条件:

CASE
    WHEN <condition>
        x
    ELSE
        z
END

但是如何针对 else-if 条件执行此操作？

像这样的东西(伪代码):

CASE
    WHEN <condition>
        x
    ELSE-IF <condition>
        y
    ELSE
        z
END

我现在的代码:

CREATE VIEW [dbo].[v_myview1]
AS
    SELECT 
        ci.aDate, ci.Currency, ci.lim, ci.LimitUS,
        pa.Date as AmtDate,
        pa.Payment as AmtPayment,
        CASE 
            WHEN (ci.aDate - pa.Date) < 0 THEN ci.LimitUS
            --ELSE IF
            --WHEN (ci.lim - pa.Payment) < 0 THEN 'a'
            ELSE 'b'
        END AS Estimate,
    FROM
        dbo.Amt pa
    JOIN 
        dbo.CrInfo ci ON ci.pr_key = pa.pr_key
    JOIN
        dbo.rates tr ON rt.Currency = ci.Currency 
    WHERE 
        ci.mk = 2

Answer 1

你可以像这样使用第二种情况:

CASE 
WHEN (ci.aDate - pa.Date) < 0 THEN  ci.LimitUS
WHEN (ci.lim - pa.Payment) < 0 THEN 'a'
ELSE 'b'