select
    i.item_code CODE,
    case
        when ih.item_name is null or i.item_name != ih.item_name then i.item_name
        else null
    end NAME
from item i
left join item_history ih
    on i.item_code = ih.item_code
order by i.item_code desc