Which of the following set of functions is a valid set of aggregate functions…
2023
Which of the following set of functions is a valid set of aggregate functions in MySQL?
- A.
AVG(), ROUND(), COUNT()
- B.
MIN(), UPPER(), AVG()
- C.
COUNT(), MAX(), SUM()
- D.
DATE(), COUNT(), LTRIM()
Attempted by 2305 students.
Show answer & explanation
Correct answer: C
In MySQL, aggregate functions are used to perform calculations on a set of values and return a single value. Valid aggregate functions include: COUNT() → counts number of rows
MAX() → returns maximum value
SUM() → returns total sum
Other options include non-aggregate functions like UPPER(), ROUND(), DATE(), LTRIM(), so they are not correct.
A video solution is available for this question — log in and enroll to watch it.