AGGREGATE FUNCTION

The aggregate functions are :-

1) COUNT

2) SUM

3) MAX

4) MIN

5) AVG

INPUT –  SELECT * FROM Salary;

OUTPUT --
 

 
1) COUNT Functions used :--
 
SYNTAX – COUNT [ (*) \ (DISTINCT \ ALL) ] (COLUMN NAME)

INPUT – SELECT COUNT(*) FROM Salary;

OUTPUT—



INPUT – SELECT Department, COUNT(FirstName) AS UserName
                FROM Salary
                GROUP BY Department;

OUTPUT—



INPUT – SELECT Position,COUNT(FirstName) AS UserName
                FROM Salary
                GROUP BY Position;

OUTPUT –

 

2) SUM Functions Used :-

SYNTAX – SUM( [DISTINCT] COLUMN NAME)

INPUT – SELECT SUM(Salary),SUM(Bonus)
                FROM Salary;

OUTPUT –



INPUT – SELECT Department,SUM(Salary)+SUM(Bonus)
                FROM Salary
                GROUP BY Department;

OUTPUT –

 

3) MAX Functions Used :-


SYNTAX – MAX( [DISTINCT] COLUMN NAME)



INPUT – SELECT MAX(Salary)
                FROM Salary;

OUTPUT –

 

4) MIN Functions Used :-


SYNTAX – MIN( [DISTINCT] COLUMN NAME)


INPUT – SELECT MIN(Salary)
                FROM Salary;

OUTPUT –

 

5) AVG Functions Used :-


SYNTAX – AVG( [DISTINCT] COLUMN NAME)


INPUT – SELECT Department,AVG(Salary)
                FROM Salary
                GROUP BY Department;

OUTPUT –