qq_33765174的博客

 begin         select e.barcode into xbarcode           from (select t.itemnumber,t.barcode,                        row_number() OVER(PARTITION BY itemnumber ORDER BY t.itemnumber desc) as row_flg    ...

 select e.barcode           from (select t.itemnumber,t.barcode,                        row_number() OVER(PARTITION BY itemnumber ORDER BY t.itemnumber desc) as row_flg                      from itemb...