Multiple choice technology databases

Which of the following is not a group function?

  1. avg()

  2. sqrt()

  3. max()

  4. sum()

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Group functions (aggregate functions) operate on sets of rows and return a single result. avg(), max(), and sum() are all group functions. sqrt() is a single-row function that operates on individual values.