CASE WHEN 嵌套

最新推荐文章于 2026-01-06 04:17:30 发布

原创最新推荐文章于 2026-01-06 04:17:30 发布 · 3.1k 阅读

2 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#SQL

收录于

My SQL 专栏收录该内容

21 篇文章

订阅专栏

本文详细探讨了SQL中的CASE WHEN语句，它作为流程控制工具，用于在查询中实现条件判断和复杂逻辑。通过对CASE WHEN的嵌套使用，可以处理更复杂的查询场景，实现数据的灵活筛选和转换。

记录CASE WHEN 流程控制语句

SELECT
    'PAID' AS '维度',
    CASE
WHEN t2.PRINCIPAL_DUE IN ('1000', '1700') THEN
IF (
    SUM(t1.ORDER_AMT) >= t2.PRINCIPAL_DUE * 0.7,
    t2.PRINCIPAL_DUE * 0.7,
    SUM(t1.ORDER_AMT)
)
WHEN t2.PRINCIPAL_DUE IN ('1186') THEN
IF (
    SUM(t1.ORDER_AMT) >= 830,
    830,
    SUM(t1.ORDER_AMT)
)
WHEN t2.PRINCIPAL_DUE IN ('640', '1200') THEN
IF (
    SUM(t1.ORDER_AMT) >= t2.PRINCIPAL_DUE,
    t2.PRINCIPAL_DUE,
    SUM(t1.ORDER_AMT)
)
END  AS 'PAID'
FROM
    wmmm_loan.payment_order t1
LEFT JOIN wmmm_loan.loan_repay_plan t2 ON t1.LOAN_ID = t2.LOAN_ID
WHERE
    t2.PLAN_DUE_DATE = CURDATE() - INTERVAL 1 DAY
AND t2.MAX_OVERDUE_DAYS > 0
AND t1.ORDER_STATUS IN ('SUCCESSFUL')
AND t1.CREATE_TIME < CURDATE()