Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Window function (SQL)
open-in-new
<p>In <a href="/facts/SQL/UjQLJcYm">SQL</a>, a window function or analytic function is a function which uses values from one or multiple <a href="/facts/Row_(database)/PIpv7c9e">rows</a> to return a value for each row. (This contrasts with an <a href="/facts/Aggregate_function/685obrqz">aggregate function</a>, which returns a single value for multiple rows.) Window functions have an OVER clause; any function without an OVER clause is not a window function, but rather an aggregate or single-row (scalar) function. </p>