Window function

In SQL and other data processing frameworks, a **window function** is a type of function that performs calculations across a set of table rows that are related to the current row. Unlike regular aggregate functions, which return a single value after grouping rows, window functions allow you to perform calculations across multiple rows while still retaining the individual row details in the output. Window functions are often used for tasks such as calculating moving averages, running totals, and ranking.