oracle case when 用法

来源:互联网 发布:给排水画图软件 编辑:程序博客网 时间:2024/05/18 22:45
update studentsset 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 gradefrom students) awhere a.id = students.id)/
原创粉丝点击