Check sibling questions

Which of the following is not an aggregate function?

(A) AVG

(B) MAX

(C) JOIN

(D) COUNT

 

Answer:

Aggregate functions are those functions which performs a calculation on a set of values and returns a single value.

Aggregate function

Description

AVG( )

Returns the average of a set of values .

SUM( )

Returns the sum of a set of values .

COUNT( )

Returns the number of rows that matches a specific criterion

MIN( )

Returns the minimum value in a set of values

MAX( )

Returns the maximum value in a set of values

 

Checking the options:

  • (A) AVG - It is an aggregate function  
  • (B) MAX - It is an aggregate function   
  • (C) JOIN - It is not an aggregate function 
  • (D) COUNT - It is an aggregate function  

So, the correct answer is (C)

549 people joined Teachoo Black. What are you waiting for?


Transcript

Which of the following is not an aggregate function? (A) AVG (B) MAX (C) JOIN (D) COUNT Answer: Aggregate functions are those functions which performs a calculation on a set of values and returns a single value. Aggregate function Description AVG( ) Returns the average of a set of values. SUM( ) Returns the sum of a set of values. COUNT( ) Returns the number of rows that matches a specific criterion MIN( ) Returns the minimum value in a set of values MAX( ) Returns the maximum value in a set of values Checking the options: (A) AVG - It is an aggregate function (B) MAX - It is an aggregate function (C) JOIN - It is not an aggregate function (D) COUNT - It is an aggregate function So, the correct answer is (C)

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.