Enhanced Analytic Functions

Window functions now support the EXCLUDE options of the SQL standard window frame clause. The query_block clause of a SELECT statement now supports the window_clause, which implements the window clause of the SQL standard table expression as defined in the SQL:2011 standard.

Supporting the full ANSI standard enables easier migration of applications that were developed against other standard-compliant database systems.

Practice: Using Enhanced Analytic Functions

This practice shows how to benefit from the new options of the window frame clause, GROUPS and EXCLUDE, and also from the WINDOW clause in the table expression.

Related Topics