Syntax

The aggregate functions can also be used as window functions with the OVER () clause. See for more information.

9.1 FILTER Clause for Aggregate Functions

It can be thought of as a more explicit form of using an aggregate function with a condition (decode, case, ) to ignore some values that would otherwise be considered by the aggregation.

The clause can be used with any aggregate functions in aggregate or windowed (OVER) statements, but not with window-only functions like DENSE_RANK.

Example of FILTER

The FILTER clause lets you express those conditions more explicitly:

Tip