表a如下
name age id ass
七 18 1 5
想得到的数据如下
name age id 5
七 18 1 1
七 19 1 1
七 20 1 1
七 21 1 1
七 22 1 1
没主键 oracle
select t.name,t.age,1 as num from (
select '七' as name,18 as age,5 as num from dual
) t connect by level <= t.num
RANGE(1,ass,1)
1min目标场景问卷
立即参与
