摘要:
示例一SELECT 学号, 姓名,等级= CASE WHEN 总学分 IS NULL THEN ‘尚未选课’ WHEN 总学分 < 50 THEN ‘不及格’ WHEN 总学分 >=50 and 总学分<=52 THEN ‘合格’ ELSE ‘优秀’ END FROM XS WHERE 专业名=’计算机’示例二update employeeset e_wage =case when job_level = ’1’ then e_wage*1.08 when job_level = ’2’ then e_wage*1.07 when job_level = ’3’ then e 阅读全文
posted @ 2012-02-21 13:41
pantherbean
阅读(3621)
评论(0)
推荐(0)
浙公网安备 33010602011771号