insert into tb2 (code,name) 
select code,min(name) from tb1 where code is not null or upper(code)!='NULL'
group by code

------解决方案--------------------

insert into tb2 (code,name) 
select code,min(name) from tb1 where code is not null group by code,name