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:
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:
“As the end of the century approaches, all our culture is like the culture of flies at the beginning of winter. Having lost their agility, dreamy and demented, they turn slowly about the window in the first icy mists of morning. They give themselves a last wash and brush-up, their ocellated eyes roll, and they fall down the curtains.”
—Jean Baudrillard (b. 1929)
“Nobody seriously questions the principle that it is the function of mass culture to maintain public morale, and certainly nobody in the mass audience objects to having his morale maintained.”
—Robert Warshow (1917–1955)