有沒有辦法在 Athena/Presto 中使用多個 WITH 陳述句？
WITH "revenue" AS (
SELECT
"cik",
"accession",
"year",
"quarter",
"form type" as "form_type",
CAST("value" AS bigint) as "revenue",
CAST("value" - lag("value") over (partition by "cik") AS bigint) as "increment",
ROUND("value" / lag("value") over (partition by "cik"),2) as "ratio"
FROM "gaap"
WHERE
"form type" IN ('10-K')
AND "rep" = 'revenue'
ORDER BY
"cik", "year", "quarter", "fs" desc
)
WITH "cik_with_continuous_growth" AS (
SELECT "cik"
FROM "revenue"
WHERE
"ratio" >= 1.5
AND "year" >= 2016
GROUP BY "cik"
HAVING COUNT("ratio") >= 3
ORDER BY "cik"
)
SELECT * FROM "cik_with_continuous_growth";
錯誤
只允許一條 sql 陳述句。得到： WITH "revenue" AS ( SELECT "cik", "accession", "year", "quarter", "form type" as "form_type", CAST("value" AS bigint) as "revenue", CAST(" value" - lag("value") over (partition by "cik") AS bigint) as "increment", ROUND("value" / lag("value") over (partition by "cik"),2) as " ratio" FROM "gaap" WHERE "form type" IN ('10-K') AND "rep" = 'revenue' ORDER BY "cik", "year", "quarter", "fs" desc ) WITH "cik_with_continuous_growth" AS（從“收入”中選擇“cik”，其中“比率”> = 1.5 AND“年份”> = 2016 GROUP BY "cik" HAVING COUNT("ratio") >= 3 ORDER BY "cik" ) SELECT * FROM "cik_with_continuous_growth"; #WHERE "收入"."cik" = "cik_with_continuous_growth"."cik";
uj5u.com熱心網友回復：
WITH "revenue" AS (,
SELECT "cik", "accession", year, quarter.
"form type" as "form_type",
CAST("value" AS bigint) as "revenue",
CAST("value" - lag("value") over (partition by "cik") AS bigint) as "increment",
ROUND("value" / lag("value") over (partition by "cik"),2) as "ratio"
FROM "gaap"
WHERE "form type" IN ('10-K') AND
"rep" = 'revenue' AND
ORDER BY "cik", "year", "quarter", "fs" desc
),
"cik_with_continuous_growth" AS (
SELECT "cik"
FROM "revenue"
WHERE "ratio" >= 1.5 AND
"year" >= 2016
GROUP BY "cik"
HAVING COUNT("ratio") >= 3
ORDER BY "cik"
)
SELECT * FROM "cik_with_continuous_growth";
uj5u.com熱心網友回復：
你試過with a as ( ) , b as () select * from a,b嗎？
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/413621.html
標籤：