Which of the following is not a valid aggregate function?
2023
Which of the following is not a valid aggregate function?
Answer: B. COMPUTE — Aggregate functions are used in SQL to perform calculations on a set of values and return a single value. Common aggregate functions include COUNT, SUM, AVG,…
- A.
COUNT
- B.
COMPUTE
- C.
SUM
- D.
More than one of the above
- E.
None of the above
Attempted by 2061 students.
Show answer & explanation
Correct answer: B
Aggregate functions are used in SQL to perform calculations on a set of values and return a single value. Common aggregate functions include COUNT, SUM, AVG, MIN, and MAX. COUNT is used to count the number of rows in a group. SUM is used to calculate the total of a numeric column. These are valid aggregate functions. COMPUTE is not a standard aggregate function in SQL. It is not recognized in standard SQL syntax for aggregation. Therefore, it is not a valid aggregate function.