Multiple choice technology databases

Which is not a group function?

  1. Count

  2. Avg

  3. Total

  4. Max
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Standard SQL group/aggregate functions include COUNT, AVG, MAX, MIN, SUM, STDDEV, and VARIANCE. TOTAL is not a standard SQL aggregate function - the standard uses SUM for totaling values. While some databases might implement TOTAL, it's not part of core SQL group functions.

Keep practicing — related questions