I'm using PLSQL. How do I select one of the retrieved data?

aoturen

select temp.itemno
            into v_sku
            from t_goods_re_temp temp
            where temp.itemtype = v_itemtype and temp.itemspec = v_itemspec and temp.bandname = v.bandname;
Select one of the data that meets these conditions. How should I write it?

Help!

whbilly

select temp.itemno
            into v_sku
            from t_goods_re_temp temp
            where temp.itemtype = v_itemtype and temp.itemspec = v_itemspec and temp.bandname = v.bandname and rownum <2;