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:

    When we locked up the house at night,
    We always locked the flowers outside
    And cut them off from window light.
    Robert Frost (1874–1963)

    The information links are like nerves that pervade and help to animate the human organism. The sensors and monitors are analogous to the human senses that put us in touch with the world. Data bases correspond to memory; the information processors perform the function of human reasoning and comprehension. Once the postmodern infrastructure is reasonably integrated, it will greatly exceed human intelligence in reach, acuity, capacity, and precision.
    Albert Borgman, U.S. educator, author. Crossing the Postmodern Divide, ch. 4, University of Chicago Press (1992)