MySQL
MySQL 8.x 中的 Window 函数。
Window functions are permitted only in the select list and ORDER BY clause. Query result rows are determined from the FROM clause, after WHERE, GROUP BY, and HAVING processing, and windowing execution occurs before ORDER BY, LIMIT, and SELECT DISTINCT.
The definition of a window used with a window function can include a frame clause. A frame is a subset of the current partition and the frame clause specifies how to define the subset.
参考：https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
网友评论