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 average value of numeric data in a column. The join keyword is for combining tables, len returns string length, and left is a string function for extracting substrings. None of these are aggregate functions, which return a single calculated value from multiple rows.

Keep practicing — related questions