Past Year - 1 Mark Questions

Computer Science - Class 12
Chapter 9 - Structured Query Language

This question asked in CBSE SQP-2021

## Write any one aggregate function used in SQL.

Aggregate functions are those functions which performs a calculation on a set of values and returns a single value.

One aggregate function used in SQL is COUNT( )

Aggregate function used in SQL are

 Aggregate function Description AVG( ) Returns the average of a set of values . SUM( ) Returns the sum of a set of values . COUNT( ) Returns the number of rows that matches a specific criterion MIN( ) Returns the minimum value in a set of values MAX( ) Returns the maximum value in a set of values

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class

### Transcript

This question asked in CBSE SQP-2021 Write any one aggregate function used in SQL. Answer: Aggregate functions are those functions which performs a calculation on a set of values and returns a single value. One aggregate function used in SQL is COUNT( ) Aggregate function used in SQL are Aggregate function Description AVG( ) Returns the average of a set of values. SUM( ) Returns the sum of a set of values. COUNT( ) Returns the number of rows that matches a specific criterion MIN( ) Returns the minimum value in a set of values MAX( ) Returns the maximum value in a set of values 