在使用带有ORDER BY子句的聚合窗口函数时,需要添加一个FRAME子句以指定窗口的范围。以下是一个示例查询,其中COUNT聚合函数与ORDER BY子句一起使用,并添加了一个ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW的帧子句。
SELECT column1, COUNT(column2) OVER (ORDER BY column2) as count_column2
FROM my_table
WINDOW my_window AS (ORDER BY column2 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW);
上一篇:aggregatetypeandmovesemantic:referencesneeded
下一篇:Aggregating(Non-running)WeeklySumstoCreateaWideTable(SQL)