between 的运用.sql

初学者

SELECT '成绩分数段'= CASE WHEN STU_SCORE BETWEEN 0 AND 59 THEN '不及格'
                           WHEN STU_SCORE BETWEEN 60 AND 69 THEN '及格'
                           WHEN STU_SCORE BETWEEN 70 AND 89 THEN '良'
                           WHEN STU_SCORE BETWEEN 90 AND 99 THEN '优'
                           ELSE '未知' END ,
STU_NAME AS'学生姓名'
FROM STUDENT
/*BETWEEN 的运用*/