In SQL, __________ is an Aggregate function.
2017
In SQL, __________ is an Aggregate function.
- A.
SELECT
- B.
CREATE
- C.
AVG
- D.
MODIFY
Attempted by 2144 students.
Show answer & explanation
Correct answer: C
Answer: AVG is an aggregate function.
What is an aggregate function? Aggregate functions perform calculations on sets of rows and return a single summary value (for example: sum, average, count).
AVG details: AVG(column_name) computes the average of the numeric values in the specified column. Example: AVG(salary) returns the average salary across the selected rows.
SELECT is a statement used to retrieve rows from a table; it is not an aggregate function, though it is used together with aggregate functions to return aggregated results.
CREATE is a Data Definition Language command used to create databases or tables; it does not compute aggregated values.
MODIFY is not an aggregate function. In some SQL dialects, MODIFY or ALTER is used to change table structure or column definitions; it does not perform aggregation.
A video solution is available for this question — log in and enroll to watch it.