AVG OVER

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

​

Syntax

AVG( <value> ) OVER ( [ PARTITION BY <partition_by> ] )

​

Parameters

​

Return Types

• NUMERIC if the input is type INTEGER, BIGINT or NUMERIC
• DOUBLE PRECISION if the input is type REAL or DOUBLE PRECISION

​

Example

SELECT
	nickname,
	level,
	currentscore,
	AVG(game_score) OVER (PARTITION BY level) AS score_average
FROM
	class_test;