假設您要在按序列生成密鑰之前對數據進行分組，那么就像您想要的那樣

INSERT INTO HISTORICAL_CAR_STATS (

HISTORICAL_CAR_STATS_ID,

YEAR,

MONTH,

MAKE,

MODEL,

REGION,

AVG_MSRP,

CNT)

SELECT MY_SEQ.nextval,

year,

month,

make,

model,

region,

avg_msrp,

cnt

FROM (SELECT '2010' year,

'12' month,

'ALL' make,

'ALL' model,

REGION,

sum(AVG_MSRP*COUNT)/sum(COUNT) avg_msrp,

sum(cnt) cnt

FROM HISTORICAL_CAR_STATS

WHERE YEAR = '2010'

AND MONTH = '12'

AND MAKE != 'ALL'

GROUP BY REGION)

總結

以上是生活随笔為你收集整理的oracle sql语句序列,Oracle SQL：使用Select语句插入序列的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。