有表T1(seq_id_1, chn_id, stat_time, corp_id, fee)和
表T2(seq_id_2, chn_id, stat_time, fee),
其中seq_id_1,是T1的主键,由SEQUENCE(seq_1)产生,
seq_id_2是T2的主键,由SEQUENCE(seq_2)产生,
现需将T1中的数据插入到T2中,T2中的fee是T1中fee的和????
表T2(seq_id_2, chn_id, stat_time, fee),
其中seq_id_1,是T1的主键,由SEQUENCE(seq_1)产生,
seq_id_2是T2的主键,由SEQUENCE(seq_2)产生,
现需将T1中的数据插入到T2中,T2中的fee是T1中fee的和????
select seq_2.nextval,chn_id, stat_time,sum(fee) over()
from t1
select Seq_2.nextval,
T2.Chn_Id,
T2.Stat_Time,
sum(T2.Fee)
from T2
group by T2.Corp_Id;