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)

Learn Intergation from Davneet Sir - Live lectures starting soon!


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 - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.