-- 当ID在1至9时，取值A，10-19时，取值B，其它都为C
select case
when id between 1 and 9 then 'A'
when id between 10 and 19 then 'B'
else 'C' end as value
from tbxxx
select case
when id between 1 and 9 then 'A'
when id between 10 and 19 then 'B'
else 'C' end as value
from tbxxx
温馨提示：内容为网友见解，仅供参考
无其他回答
相似回答
