Define Over clause in sql server.

Question

Manish Kumar · Answer

The Over clause combined with partition by is used to break up data into partitions.The specified function operates for each function

Syntax

FUNCTION(..) over(PARTITION BY COL1,COL2)

Any of the following function can be used

COUNT(),AVG(),SUM(),MIN(),MAX(),ROW_NUMBER(),RANK(),

DENSE_RANK() etc

interview