- Not for
min()andmax()
Exclude current row removes the current row from the selection of the frame.
SELECT SUM(x) OVER(ORDER BY val ... [EXCLUDE NO OTHERS])
FROM ...Frame exclusion is independent of the frame unit
In context for the exclude clause, current row really just means the current row—also for range and groups frames.
Related
Tutorial: Window Frame Exclusion
Other forms:
windowclause
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".
