Multiple choice sql

Which of following denotes a single value function used in SQL?

  1. COUNT()

  2. SQRT()

  3. AVG()

  4. ALL OF THESE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQRT() is a scalar function that returns a single value (square root). COUNT() and AVG() are aggregate functions that work on multiple rows and return a single aggregated value. The question asks for a single-value (scalar) function.

Keep practicing — related questions