A function that generates a single value from a group of values, often used with GROUP BY and HAVING clauses. Aggregate functions include AVG, COUNT, MAX, MIN, and SUM. Also known as set functions. See also scalar function.

Synonym for column function.

One of a group of database functions that calculates summary information on a group of rows.

a function such as count() or sum() that you can use to calculate totals

a function that computes a single value from a series of inputs, such as computing the sum or average of a series of numbers

a function that operates on a set of values (typically one column from each row that matches a query condition) and returns a single value computed from all these values

a function that performs calculations on a column in a set of rows

a special kind of function which operates on several rows of a query at once, returning a single result

A function that performs a mathematical operation on a set of rows selected by a query and returns a single value that contains information about those rows: for example, sum, average, or count.

(SQL) Function that operates on a group of rows, for example, SUM. functions.php

A function used to calculate totals; examples include SUM, COUNT, AVG, or VAR.

A function that performs a mathematical operation on a set of rows selected by a query and returns a single value that contains information about those rows. Aggregates use one or more support functions to perform the aggregate operations. Examples of built-in aggregates include SUM, AVG, and COUNT.

In a query, a function such as COUNT, AVG, or STDEV that calculates a value using all the rows in a column of a table. In writing expressions and in programming, you can use SQL aggregate functions (including the three listed above) and domain aggregate functions to determine various statistics.

A function which calculates a value from a group of values, such as AVG (the average of the values), SUM (the sum of all values), or MAX (the maximum of all values), normally used in combination with a grouping of values by a certain attribute.

In computer science, an aggregate function is a function that compute a single result value from a collection of input values such as a set, a bag or a list.