PostgreSQL - AGGREGATE FUNCTION day 3

** AGGREGATE FUNCTIONS:**

• Aggregate function is used to perform the calculation on set input values and return the single value .

• Aggregate functions are:

• sum,avg,min,max,and count

SUM()

select sum(empsalary) from employee;

MIN()

select min(empsalary) from employee;

MAX()

select max(empsalary) from employee;

AVG()

select avg(empsalary) from employee;

output:

ROUND()

GROUPBY

• The GROUP BY clause groups rows that have the same values into summary rows

select emproll ,sum(salary) from employee group by emproll;

output: