select * from (
select a.*,row_number() over (partition by guid,item,corp order by item) rn
from corpitem a
) where rn=1
select * from (
select a.*,row_number() over (partition by guid,item,corp order by item) rn
from corpitem a
) where rn=1