SQL Tutorial

27 / 60

Aggregate Functions

An aggregate function is a function where the values of multiple rows are grouped together to form a single value of more significant meaning or measurements such as a set, a bag or a list.

select max(empsal) from emp;

select avg(empsal) from emp;

select sum(empsal) from emp;

select count(empsal) from emp;