update students set grade = ( select grade from ( select id, case when current_credits > 90 then 'a' when current_credits > 80 then 'b' when current_credits > 70 then 'c' else 'd' end grade from students ) a where a.id = students.id ) /
oracle case when 用法
最新推荐文章于 2024-04-18 16:05:18 发布