Report aggregation family syntax

The syntax for the report aggregation family is as follows:
Func( [DISTINCT] value_expression ) OVER ( )
or 
Func( [DISTINCT] value_expression) OVER (PARTITION BY value_expression 
[, …] )

Functions are detailed in the following section, as they are similar to those functions in the window aggregate family. Reporting functions are used only in the SELECT or ORDER BY clauses. The functions make multiple passes over a single query block without doing a self-join. Because the OVER clause can only contain a partition column list, a report aggregate has the same value in each row of the partition.