SQL Server Window Function OVER(PARTITION BY)

PARTITION BY divides the query result sets into partitions or groupings we defined. And for each partitions Window Functions are applied separately.