We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
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.
The Report
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.