select e.barcode
from (select t.itemnumber,t.barcode,
row_number() OVER(PARTITION BY itemnumber ORDER BY t.itemnumber desc) as row_flg
from itembarcode t )e
where e.row_flg = '1'
--and temp.goodsnumber=e.itemnumber;
select t.itemnumber,t.barcode,
row_number() OVER(PARTITION BY itemnumber ORDER BY t.itemnumber desc) as row_flg
from itembarcode t 查出数据分组
最后取row_flg = '1'的数据