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:
“The knocking out of a pipe can be made almost as important as the smoking of it, especially if there are nervous people in the room. A good, smart knock of a pipe against a tin wastebasket and you will have a neurasthenic out of his chair and into the window sash in no time.”
—Robert Benchley (1889–1945)
“If the children and youth of a nation are afforded opportunity to develop their capacities to the fullest, if they are given the knowledge to understand the world and the wisdom to change it, then the prospects for the future are bright. In contrast, a society which neglects its children, however well it may function in other respects, risks eventual disorganization and demise.”
—Urie Bronfenbrenner (b. 1917)