Small. Fast. Reliable.
Choose any three.

over-clause

OVER window-name ( base-window-name PARTITION BY expr , ORDER BY ordering-term , frame-spec )

Used by:   expr

References:   expr   frame-spec   ordering-term

See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html