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:
“Then is what you see through this window onto the world so lovely that you have no desire whatsoever to look out through any other window?and that you even make an attempt to prevent others from doing so?”
—Friedrich Nietzsche (18441900)
“The uses of travel are occasional, and short; but the best fruit it finds, when it finds it, is conversation; and this is a main function of life.”
—Ralph Waldo Emerson (18031882)