Question 64Asked in BPSC TRE 1.0 (2023) Computer Science Class 11-12

Which of the following is not a valid aggregate function?

  1. ACOUNT
  2. BCOMPUTE
  3. CSUM
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (B) COMPUTE

Explanation

COUNT, SUM, AVG, MIN and MAX are aggregate functions. COMPUTE is not a standard SQL aggregate function.

From BPSC TRE 1.0 (2023) Computer Science Class 11-12 — Previous Year Paper

This is question 64 of BPSC TRE 1.0 (2023) Computer Science Class 11-12 — Previous Year Paper. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.