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 figure of the gunman in the window was inextricable from the victim and his history. This sustained Oswald in his cell. It gave him what he needed to live. The more time he spent in a cell, the stronger he would get. Everybody knew who he was now.”
—Don Delillo (b. 1926)
“To make us feel small in the right way is a function of art; men can only make us feel small in the wrong way.”
—E.M. (Edward Morgan)