MySQL → Aggregation functions - MySQL → MCQ Details
MCQ Practice Single Best Answer Topic: Aggregation functions - MySQL

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

Question ID
#15496
Subchapter
Aggregation functions - MySQL
Action
Choose one option below

Choose Your Answer

Click an option to check whether your answer is correct.

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

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.

Related Topics

Explore more questions from similar topics.

Aggregation functions - MySQL Data Constraints and Integrity - MySQL Data definition language - MySQL Data manipulation language - MySQL Introduction to MySQL Databases Relational database concepts SQL and MySQL Stored functions and triggers - MySQL Transactions and ACID properties - MySQL

Share This Question

Share this MCQ with your friends or study group.