Analytic Functions for Partitions and Windows

Analytic functions are used in Select clauses to perform analysis for partitions or windows defined in Over clauses. You can use either aggregate analytic or window analytic functions. See Built-In Analytic Functions: Aggregate and Window for a list of the Business Analytics built-in analytic functions available to you. User-defined analytic functions may also be available.

Aggregate Analytic Functions	Plain Analytic Functions
Group and Analyze Rows with Row Detail for an example using the correlation statistical function.	Row_number, Rank and Dense_rank Example using all three of the built-in analytic functions that assign ranks or numbers to rows within a partition
Windows as Relative Subsets Within Partitions for an example calculating a moving average.	Windows to Show Selected Sibling Values to retrieve specific values relative to the current row.
Running Aggregates