17,377
社区成员
发帖
与我相关
我的任务
分享
select AA.*, ROWNUM AS RowNo
from (SELECT a.WARECODE, a.WARENAME, b.PLACECODE, b.STOCKQTY
FROM bd_ware a, ac_placestock b
where a.warecode = b.warecode(+)
and a.WARECODE Like '%010110404%'
order by warecode) AA
select AA.*
from (SELECT a.WARECODE, a.WARENAME, b.PLACECODE, b.STOCKQTY,row_number() over(order by a.warecode) rid
FROM bd_ware a, ac_placestock b
where a.warecode = b.warecode(+)
and a.WARECODE Like '%010111111-14980B%'
) AA
select AA.*
from (SELECT a.WARECODE, a.WARENAME, b.PLACECODE, b.STOCKQTY
FROM bd_ware a, ac_placestock b
where a.warecode = b.warecode(+)
and a.WARECODE Like '%010111111-14980B%'
) AA
SELECT a.WARECODE, a.WARENAME, b.PLACECODE, b.STOCKQTY
FROM bd_ware a, ac_placestock b
where a.warecode = b.warecode(+)
and a.WARECODE Like '%010111111-14980B%'
order by warecode