select
CASE t.receipt_kind
WHEN ‘1’ THEN ‘Accomodation’
WHEN ‘2’ THEN ‘Restaurant’
WHEN ‘3’ THEN ‘Shop’
WHEN ‘4’ THEN ‘Others’
END Sector,
from t_rmm_receipt t
where 1=1
case到end之间相当于一个具体的值,可以做运算,取别名,嵌套case 。
Oracle case when
最新推荐文章于 2023-07-28 15:11:45 发布