Question

Which of the following set of operations is a valid set of aggregate operations in SQL?
1. COUNT, MAX, AVG, SUM
2. MAX, AVG, SUM, SELECT
3. UNION, COUNT, MIN, DESC
4. AVG, MIN, MAX, ASC

Answer 1

Correct Answer - Option 1 : COUNT, MAX, AVG, SUM

In SQL, Avg, Min, Max, Sum, Count is called as aggregate function. The Aggregate functions return a single value after calculating from a group of values.

• Avg() : It returns the average values
• Count() : It finds the number of rows that matches the specified condition
• Min() : It returns the minimum value
• Max() : It returns the maximum value
• Sum() : It returns the sum of values.