Multiple choice technology databases

SQL scalar functions return a single value, Among this which is Not a scalar functions?

  1. FORMAT()

  2. ROUND()

  3. UCASE()

  4. AVG()
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

AVG() is an aggregate function that calculates the average of multiple values in a column, not a scalar function. Scalar functions like FORMAT(), ROUND(), and UCASE() operate on individual values and return a single value per row.

Keep practicing — related questions