Multiple choice technology web technology

Which of the following are belong to GROUP functions?

  1. AVG

  2. COUNT

  3. MAX

  4. STDDEV

  5. LENGTH

  6. All the above.
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

SQL GROUP functions (also called aggregate functions) perform calculations on sets of rows and return a single result. AVG, COUNT, MAX, and STDDEV are all GROUP functions that compute statistics across multiple rows. LENGTH, however, is a single-row function that operates on individual string values, not groups. The option 'All the above' is incorrect because it includes LENGTH which doesn't belong to GROUP functions.

Keep practicing — related questions