Can I use… over(… exclude …)

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.