Define Over clause in sql server.

Total Post:123

Points:615
 293  View(s)
Ratings:
Rate this:
  1. Post:123

    Points:615
    Define Over clause in sql server.

    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


      Modified On Nov-23-2017 11:02:06 PM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!