# 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.
McGraw-Hill Dictionary of Scientific & Technical Terms, 6E, Copyright © 2003 by The McGraw-Hill Companies, Inc.

## 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.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
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.
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.
Version 6 includes new functionality to create user-defined aggregate functions built upon MarkLogic's parallel-processing architecture.
Site: Follow: Share:
Open / Close