Aggregate Functions
The adapter supports the following SQL-92 summary functions.
Examples of Aggregate Functions
AVG
Returns the average of the column values.
SELECT AVG(Balance) FROM Customers
MIN
Returns the minimum column value.
SELECT MIN(Balance) FROM Customers
MAX
Returns the maximum column value.
SELECT MAX(Balance) FROM Customers
SUM
Returns the total sum of the column values.
SELECT SUM(Balance) FROM Customers WHERE Country = US