我試圖在視圖中添加這個查詢，雖然測驗它作業正常并且沒有語法錯誤但是當點擊保存時，我得到這個錯誤
ORA-00907: 缺少右括號
這是查詢：
SELECT
importer_id,
AVG(count),
STDDEV(count),
AVG(count) STDDEV(count) * 2 AS baseline
FROM
(SELECT
COUNT(declaration_identifier) AS count,
EXTRACT(MONTH FROM declaration_date) AS month,
importer_id
FROM
declaration
GROUP BY
importer_id,
EXTRACT(MONTH FROM declaration_date)
)
GROUP BY
importer_id
uj5u.com熱心網友回復：
我創建了一個虛擬表來編譯您的視圖。
create table declaration
( declaration_identifier integer,
declaration_date date,
importer_id integer
);
然后我用 CREATE VIEW 包裝了您的查詢...
CREATE VIEW SO_ERROR
AS SELECT
imp_id as id,
AVG(count) as count,
STDDEV(count) as stddev,
AVG(count) STDDEV(count) * 2 as baseline
FROM
(
SELECT
COUNT(declaration_identifier) count,
EXTRACT(MONTH FROM declaration_date) month,
importer_id imp_id
FROM
declaration
GROUP BY
importer_id,
EXTRACT(MONTH FROM declaration_date)
)
GROUP BY
imp_id;
請注意，外部選擇中的每一列都有一個別名。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/414574.html
標籤：