You are viewing a single comment's thread. Return to all 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.