oracle9i以后
rec_num ID item_num rec_qty
select rec_num,
row_number() over (partition by rec_num order by item_num) id,
item_num,
rec_qty
from 表名
rec_num ID item_num rec_qty
select rec_num,
row_number() over (partition by rec_num order by item_num) id,
item_num,
rec_qty
from 表名
select rec_num,
row_number() over (partition by rec_num order by item_num) id,
item_num,
rec_qty
from 表名
kingkingkingking(南极飘雪)
tgm78()
给分