ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Which among the following belongs to an "aggregate function"?

Answer & Solution
Correct Answer: Option A
This question is about aggregate functions in MySQL. Aggregate functions are special functions that work with groups of rows in your database table. They summarize data to give you a single value for each group.
Let's look at the options:
Option A: COUNT
This function counts the number of rows in a table or a specific column. It's an aggregate function because it combines multiple rows into a single count value.
Option B: UPPER
This function converts all the letters in a string to uppercase. It's not an aggregate function because it works on individual values within a single row, not on groups of rows.
Option C: LOWER
Similar to UPPER, this function converts all the letters in a string to lowercase. It also works on individual values and is not an aggregate function.
Option D: All of the mentioned
This option is incorrect because only COUNT is an aggregate function.
Therefore, the correct answer is Option A: COUNT.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.