🎴 Flashcard Mode
SQL Database Fundamentals and Administration
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which of the following is a SQL aggregate function
AnswerClick to flip back
A
avg
💡 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.