What is PARTITION BY in MS SQL SERVER?

Partition By Divides the query result set into partitions. The window function is applied to each partition separately and computation restarts for each partition. We use it inside Over Clause.

Syntax of Over Clause

OVER ( [ PARTITION BY value_expression ] [ order_by_clause ] )