select employee_id,case first_name when first_name = "Steve" then "My name is Steve"
else first_name
end
from hr.employees
where
employee_id = 150;
Please rectify this error for me
It's just a type. Instead of case first_name when first_name = "Steve"
you need to use case when first_name = 'Steve'
or case first_name when 'Steve'
select employee_id,case when first_name = 'Steve' then 'My name is Steve'
else first_name
end as First_Name
from hr.employees
where
employee_id = 150;