Computer Science for IGCSE & O level - Databases (Section 3 - No. 39)

What is the function of an aggregate function in SQL (e.g., `SUM`, `AVG`)?
To filter data based on specific criteria.
To perform calculations on a set of values.
To combine data from multiple tables.
To sort the data in ascending or descending order.

Explanation

Aggregate functions perform calculations (like sum, average, count) on a set of values, returning a single result.

Comments (0)

Advertisement