Multiple choice technology databases

Which of the following is a SQL aggregate function

  1. JOIN

  2. LEN

  3. LEFT

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

AVG is a SQL aggregate function that calculates the arithmetic mean of numeric values in a column. JOIN is used to combine tables, LEN returns string length, and LEFT extracts a substring - none of these are aggregate functions. Aggregate functions perform calculations across multiple rows and return single values like COUNT, SUM, AVG, MIN, MAX.

Keep practicing — related questions