Jump to content

SQL window function

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Diego Moya (talk | contribs) at 11:03, 26 September 2017 (Create stub for the concept). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

In the SQL database query language, window functions allow access to data in the recors right before and after the current record. A window function defines a frame or window of rows with a given length around the current row, and performs a calculation across the set of data in the window.