Over and PartitionBy Clause in Sql Server.

 

# Over and PartitionBy Clause 

• The OVER clause in SQL Server is used with PARTITION BY to break up the data into partitions. 

• The PARTITION BY clause is a subclause of the OVER clause. The PARTITION BY clause divides a query’s result set into partitions.In other words, PARTITION BY defines the groups into which the rows are divided.The PARTITION BY clause is basically used to partition the result set into multiple groups.