Aggregate function
Investopedia Financial Dictionary:
Top
Aggregate Function
A mathematical computation involving a set of values rather than a single value. Aggregate functions are often used in databases and spreadsheets, and include the mean or sum of a set of numbers. The calculation performed by an aggregate function returns a single value from multiple values.
Investopedia Says:
The use of computers has revolutionized the way that calculations are performed, allowing aggregate functions to produce results very quickly. In addition, aggregate functions can handle ever larger and more complex data sets, which has allowed the construction of aggregate supply and demand functions.
Related Links:
See the model in action with real data and evaluate whether its assumptions are valid. Calculating The Equity Risk Premium
Exposure to different asset classes is required to generate income, reduce risk and beat inflation. Find out how bonds can help. How To Create A Modern Fixed-Income Portfolio
If you believe the market smiles on those who focus on value, growth or income, this vehicle may be for you. Fundamentally Weighted Index Investing
If you're looking to get a job as an analyst, you'll need to know how to work it. Style Matters In Financial Modeling
This tool is easy to use and can provide valuable information on financial analysis and forecasting. Find out how. Regression Basics For Business Analysis
Wikipedia on Answers.com:
Top
Aggregate function
In computer science, 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:[1]
Aggregate functions are common in numerous programming languages such as Ruby, in spreadsheets, and in relational algebra.
SQL Aggregate Functions
SQL aggregate functions return a single value, calculated from values in a column.[2]
Useful aggregate functions:
* AVG() - Returns the average value * COUNT() - Returns the number of rows * FIRST() - Returns the first value * LAST() - Returns the last value * MAX() - Returns the largest value * MIN() - Returns the smallest value * SUM() - Returns the sum
See also
- Fold (higher-order function)
- Group by (SQL), SQL implementation
References
- ^ Cristian Calude (2001). Multiset processing: mathematical, computer science, and molecular computing points of view. Springer. p. 172. ISBN 3-540-43063-6.
- ^ Phillip A. Laplante (2001). Dictionary of computer science, engineering, and technology. CRC Press. p. 11. ISBN 0-8493-2691-5.
 |
This programming language-related article is a stub. You can help Wikipedia by expanding it. |
This entry is from Wikipedia, the leading user-contributed encyclopedia. It may not have been reviewed by professional editors (see full disclaimer)
Post a question - any question - to the WikiAnswers community:
Copyrights:
Investopedia Financial Dictionary
Copyright ©2010, Investopedia.com - Owned and Operated by Investopedia US, A Division of ValueClick, Inc. All rights reserved.
Read more
