Multiple choice technology databases

Which of the following is not a grouping function?

  1. DISTINCT

  2. SUM

  3. MIN

  4. COUNT

  5. All of the above.

  6. None of these above.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To answer this question, the user needs to know about grouping functions in SQL.

Grouping functions are used to group rows of data together and perform calculations on them. Each of the options listed is a grouping function except for one.

A. DISTINCT: This is a grouping function that returns the unique values of a column.

B. SUM: This is a grouping function that returns the sum of the values in a column.

C. MIN: This is a grouping function that returns the minimum value of a column.

D. COUNT: This is a grouping function that returns the number of rows in a table or the number of non-null values in a column.

E. All of the above: This option is incorrect because all of the options listed are grouping functions except for one.

F. None of these above: This option is also incorrect because one of the options listed is not a grouping function.

The Answer is: A. DISTINCT

AI explanation

Correct answer: DISTINCT. DISTINCT is a keyword/qualifier that filters out duplicate rows from a result set — it is not an aggregate/grouping function. SUM, MIN, and COUNT are all standard SQL aggregate (grouping) functions that operate over a set of rows to produce a single summary value.

Keep practicing — related questions