Which of the following is aggregate function in SQL?

20072007

Which of the following is aggregate function in SQL?

  1. A.

    Avg

  2. B.

    Select

  3. C.

    Ordered by

  4. 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.

Explore the full course: Isro