注册

select中的casewhen

把球给我,我要回家 2023/05/24 1740 3 已解决

从mysql迁移过来的一条sql。里面包含case when then。如下:

SELECT y.id AS "id",
             CASE
                 WHEN y.safe_strategy = '0' THEN "按表"
                 WHEN y.safe_strategy = '1' THEN "按列"
                 WHEN y.safe_strategy = '2' THEN "按行" END AS "safeStrategy",
             y.security_rule_id                           AS "securityRuleId"

      FROM data_manu_classify y

请问这么能兼容一下呢

回答 0
暂无回答
扫一扫
联系客服