1
我感觉你是想要一个“统计”表并把原始数据中的每一行生成多行😂
with numbers as (
select rownum as n
from table_01
where rownum < 50
)
select t1.start_date - n
from table_01 t1 join
numbers n
on n.n < t1.date_limit
where t1.date_ = 'DATA_FINAL';
收藏