More about the Analytic Function Template

When you paste a new Analytic Function into a Calculation box, Discoverer provides the following generic template:

OVER (PARTITION BY expr1 ORDER BY expr2)

The expressions are used as follows.

• OVER - indicates that the function operates on a query result set, after the other query clauses have been applied, (such as FROM, WHERE, HAVING etc.

• PARTITION BY - partition (or group) the query results set. E.g. PARTITION BY `Region'.

• ORDER BY - specify how the results set is logically ordered. E.g. ORDER BY `Sales SUM'.

For more information about Oracle expressions, refer to "Getting More Information".