over(… exclude current row)

1. Not for min() and max()

Exclude current row removes the current row from the selection of the frame.

SELECT SUM(x) OVER(ORDER BY val … [EXCLUDE NO OTHERS])
  FROM …

Related

• Other frame exclude options: no others, group, ties

• 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-2:2023 as part of optional feature T612, “Advanced OLAP operations”.