What is a Window Function in SQL?
Anonimo
A Window Function allows you to perform calculations across a set of rows related to the current row, without collapsing the result set. It’s commonly used with PARTITION BY and ORDER BY for grouping and sorting.