aggregate function


Also found in: Wikipedia.

aggregate function

[¦ag·rə·gət ′fəŋk·shən]
(computer science)
A command in a database management program that performs an arithmetic operation on the values in a specified column or field in all the records in the database, such as computing their sum or average or counting the number of records that satisfy particular criteria.

aggregate function

A calculation that is made on several records or cells of data. SUM, AVG, MAX, MIN and COUNT are examples of aggregate functions that are used in spreadsheets and database programs.
References in periodicals archive ?
The easiest method to determine running sums uses a domain aggregate function called DSum.
Once receiving data packets from all member nodes, CH performs Aggregate function as follows.
The Algebraic aggregate operator Entro() is implemented by the aggregate function Entro() in the SQL SELECT.
Bosc (2010) also introduced a variation of the aggregate function COUNT() on fuzzy sets defined over a fuzzy partition defined as follows:
Our operator receives as arguments: i) a spatial query window, ii) a geographic context, c) a list of aggregates, where an aggregate is an aggregate function applied to a measure, and iv) a cube.
Of Occurrences 0 Audio/Visual 2 Books 2 Null values will effect the results from an aggregate function
For an aggregate production function to exist, one must be able to aggregate different production techniques into a single aggregate function and aggregate heterogeneous outputs and inputs into aggregate indexes.
In this approach, information about the characteristics of the monetary aggregates is obtained by empirically estimating the parameters of a monetary aggregate function consisting of various monetary assets.
For each grouping field, you can define a collection of totals to be displayed - each total calculating its own aggregate function.
Individual chapters are focused on the comparative advantage and welfare impact of European integration; firms, destinations, and aggregate functions, and many other related subjects.
When the GROUP BY clause usage exists to support aggregate functions, one actually needs to sum numbers.
Emulation of intersect/except, extended aggregate functions, ALL/ANY etc, when not implemented.
Full browser ?