Multiple choice technology databases

Which of the following is a SQL aggregate function?

  1. CAST

  2. LEFT

  3. MIN

  4. RIGHT
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL aggregate functions perform calculations on multiple values and return a single value. MIN is a valid aggregate function that returns the smallest value in a column. CAST is a conversion function, while LEFT and RIGHT are string manipulation functions that extract substrings - none of these are aggregate functions.

Keep practicing — related questions