ICODEBROKER

■ CASE 함수 사용하기

------------------------------------------------------------------------------------------------------------------------

SELECT

    STUDENT_ID

   ,COURSE_ID

   ,SCORE

   ,CASE

        WHEN SCORE BETWEEN 90 AND 100 THEN 'A'

        WHEN SCORE BETWEEN 80 AND 89  THEN 'B'

        WHEN SCORE BETWEEN 70 AND 79  THEN 'C'

        WHEN SCORE BETWEEN 60 AND 69  THEN 'D'

        WHEN SCORE BETWEEN 0  AND 59  THEN 'F'

    END "등급"

FROM  TBL_SCORE

WHERE STUDENT_ID = 'C0801'

ORDER BY COURSE_ID ASC;

------------------------------------------------------------------------------------------------------------------------