case多分支.sql

来自「SQL Server数据库设计和高级查询[SQL Advance]」· SQL 代码 · 共 10 行

SELECT * FROM stuMarks  --原始成绩
print 'ABCDE五级显示成绩如下：'
SELECT stuNo,成绩= CASE  
                     WHEN writtenExam<60 THEN 'E'
                     WHEN writtenExam between 60 AND 69 THEN 'D'
                     WHEN writtenExam between 70 AND 79 THEN 'C'
                     WHEN writtenExam between 80 AND 89 THEN 'B'
                     ElSE 'A'
                  END
             FROM stuMarks