Live briefing
Everything about Window function (SQL)
Function over multiple rows in SQL
In SQL, a window function or analytic function is a function which uses values from one or multiple rows to return a value for each row. 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. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Window function (SQL)A 5-minute orientation
- Pick up a classic book: Learning PHP, MySQL & JavaScriptThe most-reprinted book on the subject
- Read the landmark paper: Efficient processing of window functions in analytical SQL queriesCited 33 times
- Go sideways: Select (SQL)A closely related topic
- Go sideways: DUAL tableA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🏆 Landmark papers (most cited)
📚 Books worth reading
Learning PHP, MySQL & JavaScriptRobin Nixon · 2009
PHP for the World Wide WebLarry Ullman · 2001
Introduction to Computing Using PythonLjubomir Perkovic · 2011
Microsoft Office 2013Misty E. Vermaat · 2014- 📕T-SQL Window FunctionsItzik Ben-Gan · 2019
Microsoft SQL Server 2012 high-performance T-SQL using Window functionsItzik Ben-Gan · 2012
CouchDBJ. Chris Anderson, Jan Lehnardt · 2010
Hitchhiker's guide to Visual studio and SQL serverWilliam R. Vaughn, Peter Blackburn · 2006
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Select (SQL) The SQL SELECT statement returns a result set of rows, from one or more tables. A SELECT statement retrieves zero or more rows from one or more database…
- DUAL table The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single…
- Comparison of relational database management systems The following tables compare general and technical information for a number of relational database management systems. Please see the individual products'…
- Hierarchical and recursive queries in SQL A hierarchical query is a type of SQL query that handles hierarchical model data. These are useful for working with databases of graph-structured data…
- Merge (SQL) A relational database management system uses SQL MERGE (also called upsert) statements to INSERT new records or UPDATE or DELETE existing records depending…
- Insert (SQL) An SQL INSERT statement adds one or more records to any single table in a relational database. Insert statements have the following form: INSERT INTO table…
- Database trigger A database trigger is procedural code that is automatically executed in response to specific events on a table or view in a database. Triggers are commonly…
- Null (SQL) In the SQL database query language, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the…