Question

Explain any four aggregate functions in SQL with syntax.

Answer 1

1. AVG – calculates the average of a set of values.
2. COUNT – counts rows in a specified table or view.
3. MIN – gets the minimum value in a set of values.
4. MAX – gets the maximum value in a set of values.
5. SUM – calculates the sum of values.

Answer 2

An aggregate function is used to provide summarization information for an SQL statement, such as counts, totals, and averages. SQL Aggregate Functions: SQL Aggregate Functions operate on complete sets of data and return a single result. PointBase supports five Aggregate Functions: AVG, COUNT, MAX, MIN, and SUM.