The Report

  • + 0 comments

    END clause will close the case statement.

    select case when grade<8 then 'NULL' else s.name end NULL will be assigned to those columns which fail the condition grade<8 i.e. students with grades less than 8.