This section covers advanced SQL techniques for in-database analytics within Greenplum.
The following techniques will be discussed in detail:
Window functions are a new class of functions introduced in Greenplum. The
WINDOW clause is used to define a window that can be used in the
OVER() expression of a window function such as
avg. For information on OLAP extensions and window functions refer to the Greenplum Database Reference guide. Window functions allow application developers to more easily compose complex OLAP queries using standard SQL commands. For example: