Question

Why are aggregate functions called so? Name some aggregate functions.

Answer 1

recutils supports aggregate functions . These are so called because they accept a record set and a field name as inputs and generate a single result. ... The supported aggregate functions are the following:

1. Count(FIELD)

Counts the number of occurrences of a field.  

2. Avg(FIELD)

Calculates the average (mean) of the numerical values of a field.  

3. Sum(FIELD)

Calculates the sum of the numerical values of a field.  

4. Min(FIELD)

Calculates the minimum numerical value of a field.  

5. Max(FIELD)

Calculates the maximum numerical value of a field.

The aggregate functions are to be invoked in the field expressions in recsel. By default they are applied to the totality of the records in a record set.