Which of the following is aggregate function in SQL?

20072007

Which of the following is aggregate function in SQL?

Answer: A. AvgAn aggregate function performs a calculation on a set of values and returns a single value. In SQL, common aggregate functions include AVG(), COUNT(), SUM(),…

  1. A.

    Avg

  2. B.

    Select

  3. C.

    Ordered by

  4. D.

    distinct

Attempted by 1922 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: Iocl Engineers Officers Grade A Paper 2

Loading lesson…