SQL Aggregate Functions

Aggregate functions calculate a single value from multiple rows. Aggregate functions ignore NULL values.

If you use a aggregate function in your query then all column expressions must be a aggregate function, a expression in the GROUP BY clause or a constant expression.

Aggregate functions are only valid in the SELECT and HAVING clause.

We have add the most popular SQL aggregate functions to the SmallSQL database. If you need a additional function that are available in another DBMS then contact our support with a feature request.

• COUNT
• SUM
• MAX
• MIN
• FIRST
• LAST
• AVG

see also:
SQL Functions
SQL Date and Time Functions
SQL Numeric Functions
SQL String Functions
SQL System Functions
SQL Syntax