SQL Basics | Functions | MAX, MIN

MAX and MIN return the maximum and minimum values of data retrieved from a table.

MAX, MIN syntax

The function for finding the maximum value is as follows.

SELECT MAX("field_name")
FROM "table_name";

The function for finding the minimum value is as follows.

SELECT MIN("field_name")
FROM "table_name";

MAX(), MIN() example

For example, suppose you want to find the maximum and minimum values of the sales field in the table below.

store_information table

Enter the following command.

SELECT MAX(sales), MIN(sales)
FROM store_information

The result can be obtained as follows.