Select (SQL) - Window Function

Window Function

A window function in SQL:2003 is an aggregate function applied to a partition of the result set.

For example,

sum(population) OVER( PARTITION BY city )

calculates the sum of the populations of all rows having the same city value as the current row.

Partitions are specified using the OVER clause which modifies the aggregate. Syntax:

:: = OVER ( )

The OVER clause can partition and order the result set. Ordering is used for order-relative functions such as row_number.

Read more about this topic:  Select (SQL)

Famous quotes containing the words window and/or function:

    O Mary, at thy window be,
    It is the wish’d, the trysted hour!
    Robert Burns (1759–1796)

    It is not the function of our Government to keep the citizen from falling into error; it is the function of the citizen to keep the Government from falling into error.
    Robert H. [Houghwout] Jackson (1892–1954)