SQL Tutorial

39 / 59

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;