src: i.ytimg.com
In database management an aggregate function is a function where the values of multiple rows are grouped together 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)
- Count()
- Maximum()
- nanmean() (mean ignoring NaN values, also known as "nil" or "null")
- Median()
- Minimum()
- Mode()
- Sum()
The listagg function, as defined in the SQL:2016 standard aggregates data from multiple rows into a single concatenated string.
Aggregate functions occur commonly in numerous programming languages, in spreadsheets, and in relational algebra.
Video Aggregate function
See also
- Cross-tabulation a.k.a. Contingency table
- Data drilling
- Data mining
- Data processing
- Drill down
- Extract, transform, load
- Fold (higher-order function)
- Group by (SQL), SQL clause
- OLAP cube
- Online analytical processing
- Pivot table
- Relational algebra
- Utility functions on indivisible goods#Aggregates of utility functions
- XML for Analysis
Maps Aggregate function
References
https://msdn.microsoft.com/en-IN/library/ms173454.aspx
src: i.ytimg.com
Further reading
- 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.
Source of the article : Wikipedia
0 Comments