What are Aggregate Functions in SQL?

SQL aggregate functions return a single value, calculated from values in a column.

Useful aggregate functions:

AVG() - the average value
COUNT() - the number of rows
FIRST() - the first value
LAST() - the last value
MAX() - the largest value
MIN() - the smallest value
SUM() - the sum

No comments: