Sql 查询结果 根据某个字段值 变更另外一个字段值 case when

SELECT
    CASE
WHEN CarType = 1 THEN
    '*******'
ELSE
    Plate
END AS Plate,
 CarType 
FROM
    Cars;

原文地址:https://www.cnblogs.com/kiween/p/9330763.html