摘要： 1:case when then else end 示例一 SELECT 学号, 姓名, 等级= CASE WHEN 总学分 IS NULL THEN ‘尚未选课’ WHEN 总学分 =50 and 总学分<=52 THEN ‘合格’ ELSE ‘优秀’ END FROM XS WHERE 专业... 阅读全文