Window function (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. (This contrasts with an aggregate function, 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.
- Comment
- enIn 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. (This contrasts with an aggregate function, 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.
- Has abstract
- enIn 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. (This contrasts with an aggregate function, 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.
- Is primary topic of
- Window function (SQL)
- Label
- enWindow function (SQL)
- Link from a Wikipage to another Wikipage
- Aggregate function
- Category:Articles with example SQL code
- Category:SQL
- Group by (SQL)
- MariaDB
- MySQL
- PostgreSQL
- Result set
- Row (database)
- Select (SQL)
- SQL
- SQL:2003
- SameAs
- 2M85n
- Fensterfunktion (SQL)
- Q24898611
- تابع پنجره (اسکیوال)
- 窓関数 (SQL)
- 窗函数 (SQL)
- Subject
- Category:Articles with example SQL code
- Category:SQL
- WasDerivedFrom
- Window function (SQL)?oldid=1123043741&ns=0
- WikiPageLength
- 8236
- Wikipage page ID
- 16060526
- Wikipage revision ID
- 1123043741
- WikiPageUsesTemplate
- Template:Reflist
- Template:Short description
- Template:SQL