# case when
select
case
when score >= 90 then 'A'
when score >= 80 then 'B'
when score >= 70 then 'C'
when score >= 60 then 'D'
else 'F'
end as grade
from t_score;
C/C++ 语言中的 if...else if...else 语句
2024-07-15 12:42:02 35 阅读