Window frames can remove certain rows with the same order by
values as the current row.
SELECT SUM(x) OVER(ORDER BY y EXCLUDE [ NO OTHERS | CURRENT ROW | GROUP | TIES ]
)
FROM …
Related
Tutorial: Window Frame Exclusion
Other forms:
window
clause
Normative References
The exclude
clause in window definitions—both, in over
and window
clauses—is defined in ISO/IEC 9075:2016-2 as part of optional feature T612.