SQL Functions - MAX, MIN, AVG

MAX function is used to get the largest value of the column name passed.
MIN function is used to get the smallest value of the column name passed.
AVG function is used to get the average value of the column name passed.

Imagine we have table called CUSTOMERS, with the following data:

Rambo

Robert

Belgium

Mugambo

Satraj

Norway

Nagashekar

Rao

India

Tom

Harry

Brazil

Dana

Laura

Australia

Rambo

Fox

New Zealand

Giselle

Chivvi

Japan

Scenario 1: Get me the largest age among the Customers. We can use MAX function for the above criteria.

SELECT MAX(AGE) from Customer

Result: 87
In the above SELECT Clause, we used MAX function on AGE column to get the largest value.

Scenario 2: Get me the smallest age among the Customers. We can use MIN function for the above criteria.

SELECT MIN(AGE) from Customer

Result: 21
In the above SELECT Clause, we used MIN function on AGE column to get the smallest value.

Scenario 3: Get me the average age of your Customer. We can use AVG function for the above criteria.

SELECT AVG(AGE) FROM Customer

Result: 43
In the above SELECT Clause, we used AVG function on AGE column to get the average value.