Multiple choice technology databases

Which functions mentioned below are GROUP functions? Choose all that apply

  1. ADD_MONTHS

  2. COUNT

  3. ROUND

  4. DISTINCT

  5. AVG

  6. SUM
Reveal answer Fill a bubble to check yourself
B,E,F Correct answer
Explanation

COUNT, AVG, and SUM are group (aggregate) functions because they operate on sets of rows to return a single value. ROUND and ADD_MONTHS are single-row functions acting on individual values, while DISTINCT is an SQL query modifier keyword rather than a function.

Keep practicing — related questions