Skip to content

case when格式化问题 #44

@BryceQin

Description

@BryceQin

格式化前:
SELECT *
FROM t
WHERE
CASE WHEN comp_cd = '0593' THEN 'USD'
WHEN comp_cd = '0594' THEN 'USD'
WHEN comp_cd = '1601' THEN 'CNY'
WHEN comp_cd = '1602' THEN 'CNY' END = t.cy_cd
格式化后:
SELECT *
FROM t
WHERE CASE WHEN comp_cd = '0593' THEN 'USD' WHEN comp_cd = '0594' THEN 'USD' WHEN comp_cd = '1601' THEN 'CNY' WHEN comp_cd = '1602' THEN 'CNY' END = t.cy_cd

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions