DEFINE OVER CLAUSE IN SQL SERVER.

Manish Sahu

Total Post:53

Points:265
Posted by  Manish Sahu
 70  View(s)
Ratings:
Rate this:
  1. Manish Sahu

    Post:53

    Points:265
    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!