window function

Also known as analytic function, PARTITION BY, OVER

kind of function in SQL; calculations across a set of table rows that are somehow related to the current row