The PARTITION BY clause of #SQL window functions splits the rows into groups It produces one group for each value in the partitioning column(s) The function operates on all the rows in each group and returns the result alongside each row