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:
“‘Who is it that this dark night
Underneath my window plaineth?’”
—Sir Philip Sidney (1554–1586)
“Our father has an even more important function than modeling manhood for us. He is also the authority to let us relax the requirements of the masculine model: if our father accepts us, then that declares us masculine enough to join the company of men. We, in effect, have our diploma in masculinity and can go on to develop other skills.”
—Frank Pittman (20th century)