Which of the following is not an ‘aggregate function’ in MySQL?
2026
Which of the following is not an ‘aggregate function’ in MySQL?
- A.
SUM()
- B.
AVG()
- C.
MOD()
- D.
COUNT()
Attempted by 1363 students.
Show answer & explanation
Correct answer: C
The correct answer is Option C (MOD()).
SUM(), AVG(), and COUNT() are aggregate functions in MySQL because they operate on a set of values and return a single result.
MOD(), on the other hand, is not an aggregate function. It performs a mathematical operation (remainder) on given numbers and works on individual values, not on a group.
Thus, MOD() is not an aggregate function.