Deprecated -Subject Database Management System › Aggregation functions - MySQL › Question #15501
Single Choice Easy

QWhich aggregation function in MySQL returns the number of distinct values in a column?

ID: #15501 Aggregation functions - MySQL 92 views
Question Info
#15501Q 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 DISTINCT ✔ ✖
Correct Answer

Explanation

The COUNT function in MySQL, when used with the DISTINCT keyword, returns the number of distinct values in a column. It counts only the unique values and disregards duplicates.

 Continue Practice
Previous Question 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 average value of a numeric column?... 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 minimum 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 sum of values in a numeric column?...