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)