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.
This practice shows how to benefit from the new options of the window frame clause,
EXCLUDE, and also from the
WINDOW clause in the table expression.