The WINDOW clause can be used to explicitly name a window, for example to avoid repetitive or confusing expressions.

A named window can be used

1. in the OVER clause to reference a window definition, e.g. OVER window_name

2. as a base window of another named or inline (OVER) window, if it is not a window with a frame (ROWS or RANGE clauses)

   ⓘ

   Note

   A window with a base windows cannot have PARTITION BY, nor override the ordering (ORDER BY) of a base window.