Informatics Practices
The avg() function in MySQL is an example of …………… .
- Math function
- Text function
- Date Function
- Aggregate Function
SQL Queries
3 Likes
Answer
Aggregate Function
Reason — The AVG() function is classified as an aggregate function because it performs a calculation on a set of values to return a single value.
Answered By
3 Likes
Related Questions
Write the output of the following SQL command :
SELECT Round(49.88);- 49.88
- 49.8
- 49.0
- 50
Predict the output of the following query :
SELECT MOD(9, 0);- 0
- NULL
- NaN
- 9
An aggregate function performs a calculation on …………… and returns a single value.
- single value
- multiple values
- no value
- none of these
Fill in the blanks:
The functions that work with one row at a time are called _________ functions.