Jump to content

SQL window function

Add links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Diego Moya (talk | contribs) at 11:08, 26 September 2017. 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 records right before and after the current record.[1][2] 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.[3][4]

References

  1. ^ "Probably the Coolest SQL Feature: Window Functions". Java, SQL and jOOQ. 2013-11-03. Retrieved 2017-09-26.
  2. ^ "Window Functions in SQL - Simple Talk". Simple Talk. 2013-10-31. Retrieved 2017-09-26.
  3. ^ "SQL Window Functions Introduction". Apache Drill. {{cite web}}: Cite has empty unknown parameter: |dead-url= (help)
  4. ^ "PostgreSQL: Documentation: 9.1: Window Functions". www.postgresql.org. Retrieved 2017-09-26.
Stub icon

This computer science article is a stub. You can help Wikipedia by expanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=SQL_window_function&oldid=802474075"