select case team
when 1 then '甲'
when 2 then ' 乙'
when 3 then '丙'
when 4 then ‘丁'
end as teamalias from 表;
SELECT
case
when team = 1 then '甲'
when team = 2 then '乙'
when team = 3 then '丙'
when team = 4 then '丁'
end
FROM
表
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024