AVG_IF
Function AVG_IF
is also found in the following categories: Window functions.
Syntax
Standard
Extended
AVG_IF( expression, condition )
AVG_IF( expression, condition
[ FIXED ... | INCLUDE ... | EXCLUDE ... ]
[ BEFORE FILTER BY ... ]
)
More info:
Description
Returns the average of all values that meet the condition
condition. If the values don't exist, it returns NULL
. Applicable to numeric data types only.
Argument types:
expression
—Fractional number | Integer
condition
—Boolean
Return type: Fractional number
Example
AVG_IF([Profit], [Profit] > 5)
Data source support
ClickHouse 21.8
, Microsoft SQL Server 2017 (14.0)
, MySQL 5.7
, Oracle Database 12c (12.1)
, PostgreSQL 9.3
, YDB
.