1.

Write the purpose of the following SQL function:count()max()min()avg()sum()

Answer»

The built-in functions associated with GROUP functions in SQL are

1. COUNT function- returns the count of records that satisfies the condition for each group of records.
Example:
SELECT department, COUNT(*)FROM employees WHERE salary > 25000 GROUP BY department;

2. MAX function- returns the maximum values from the column for each group of records.
Example:
SELECT department, MAX(salary) FROM employees GROUP BY department;

3. MIN function – returns the lowest values from the column for each group of records.
Example:

SELECT department, MIN(salary)FROM employees GROUP BY department;

4. AVG function – returns the average values from the column for each group of records.
Example:
SELECT AVG(cost) FROM products WHERE category = ‘Clothing’;

5. SUM function- returns the total values from the column for each group of records.
Example:
SELECT department, SUM(sales)FROM order_details GROUP BY department;


Discussion

No Comment Found

Related InterviewSolutions