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

In Oracle SQL, the standard group (aggregate) functions are COUNT, AVG, MAX, MIN, SUM, STDDEV, VARIANCE, etc. 'Total' is NOT a valid Oracle group function, making it the correct answer to 'which is NOT a group function'. While some other databases might have a TOTAL function, Oracle does not.

Keep practicing — related questions