[Oracle] Case 문

테이블 조회

SELECT class_cd, student_no,student_nm, kor FROM tb_grade;

CASE 문

SELECT
    CLASS_CD,
    STUDENT_NO,
    STUDENT_NM,
    KOR AS KOR_SCORE,
    CASE
        WHEN KOR >= 90 AND KOR <= 100 THEN '수'
        WHEN KOR >= 80 AND KOR <= 89 THEN '우'
        WHEN KOR >= 70 AND KOR <= 79 THEN '미'
        WHEN KOR >= 60 AND KOR <= 69 THEN '양'
        WHEN KOR < 60 THEN '가'
    END AS KOR
FROM
    TB_GRADE;