Big Data with Spark - Flat 33% OFF   Offer ends in

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;