记录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')
记录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')