Category: ASE: Functions: Aggregate Functions

ASE T-SQL - Aggregate Functions

Aggregate Functions produce a single return value of zero, one or more lines of a table. They create a summary of values which can be presented in a proprietary colum or as an additional row in the output. Aggregate Functions are predominantely used in select queries and having clauses. Except for the function count(*) all aggregate functions ignore NULL values. If a function is executed with the distinct option, all duplicate entries will be removed before calculation. Default option value is all; This option condiders all values as valid when calculating.

List of aggregate functions

ASE® provides a number of aggregate functions:

• avg()
• count_big()
• count(*)
• count()
• count_big()
• max()
• min()
• sum()

See also:

avg(),
count(*),
count(),
count_big(),
max(),
min(),
sum().