Which of the following is aggregate function in SQL?
20072007
Which of the following is aggregate function in SQL?
- A.
Avg
- B.
Select
- C.
Ordered by
- D.
distinct
Attempted by 797 students.
Show answer & explanation
Correct answer: A
An aggregate function performs a calculation on a set of values and returns a single value. In SQL, common aggregate functions include AVG(), COUNT(), SUM(), MAX(), and MIN(). The option Avg refers to the AVG() function, which calculates the average of a numeric column. Other SQL keywords like SELECT, ORDER BY, and DISTINCT are used for querying structure or filtering results, not for aggregation.
A video solution is available for this question — log in and enroll to watch it.