In database management an aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement such as a set, a bag or a list.
Common aggregate functions include :
- Average() (i.e., arithmetic mean)
- nanmean() (mean ignoring NaN values, also known as "nil" or "null")
- Group by (SQL), SQL clause
- Online analytical processing
- OLAP cube
- Fold (higher-order function)
- Pivot table
- Extract, transform, load
- Data drilling
- Drill down
- Data mining
- Data processing
- Relational algebra
- XML for Analysis
- Cross-tabulation a.k.a. Contingency table
- Utility functions on indivisible goods#Aggregates of utility functions
- Winand, Markus (2017-05-15). "Big News in Databases: New SQL Standard, Cloud Wars, and ACIDRain (Spring 2017)". DZone. Retrieved 2017-06-10.
In December 2016, ISO released a new version of the SQL standard. It introduces new features such as row pattern matching, listagg, date and time formatting, and JSON support.
- Grabisch, Michel; Marichal, Jean-Luc; Mesiar, Radko; Pap, Endre (2009). Aggregation functions. Encyclopedia of Mathematics and its Applications. 127. Cambridge: Cambridge University Press. ISBN 978-0-521-51926-7. Zbl 1196.00002.
|This programming-language-related article is a stub. You can help Wikipedia by expanding it.|