Which of the following is not a built in aggregate function in SQL? – McqOptions

MCQOPTIONS

1.	Which of the following is not a built in aggregate function in SQL?
A.	avg
B.	max
C.	total
D.	count
Answer» D. count

Discussion

No Comment Found

Related MCQs

What values does the count(*) function ignore?
Which keyword is used to rename the resulting attribute after the application of the aggregation function?
State true or false: We can rename the resulting attribute after the aggregation function has been applied
State true or false: Any attribute which is present in the having clause without being aggregated must not be present in the group by clause.
The _____ aggregation operation adds up all the values of the attribute
Choose the correct option regarding the query
Observe the given SQL query and choose the correct option.
STATE_TRUE_OR_FALSE:_ANY_ATTRIBUTE_WHICH_IS_PRESENT_IN_THE_HAVING_CLAUSE_WITHOUT_BEING_AGGREGATED_MUST_NOT_BE_PRESENT_IN_THE_GROUP_BY_CLAUSE.?$
State_true_or_false:_We_can_rename_the_resulting_attribute_after_the_aggregation_function_has_been_applied$
The _____ aggregation operation adds up all the values of the attribut?