Database Languages in SQL › Aggregation functions - MySQL › Question #15496
Single Choice Easy

QWhich aggregation function in MySQL returns the average value of a numeric column?

ID: #15496 Aggregation functions - MySQL 146 views
Question Info
#15496Q ID
EasyDifficulty
Aggregation functions - MySQLTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A AVG ✔ ✖
  • B SUM ✔ ✖
  • C COUNT ✔ ✖
  • D MIN ✔ ✖
Correct Answer

Explanation

The AVG function in MySQL is used to calculate the average value of a numeric column. It sums up all the values in the column and divides the sum by the number of rows.

 Continue Practice
No Previous Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Which aggregation function in MySQL returns the total number of non-null values in a column? Which aggregation function in MySQL returns the maximum value from a column? Which aggregation function in MySQL returns the number of rows in a result set or a specific column? Which aggregation function in MySQL returns the minimum value from a column? Which aggregation function in MySQL returns the number of distinct values in a column? Which aggregation function in MySQL returns the sum of values in a numeric column?