MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

12.21.5 Window Function Restrictions

The SQL standard imposes a constraint on window functions that they cannot be used in UPDATE or DELETE statements to update rows. Using such functions in a subquery of these statements (to select rows) is permitted.

MySQL does not support these window function features:

The parser recognizes these window constructs which nevertheless are not supported: