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