DB2 - SQL MIN() and MAX() Functions

SQL MIN() and MAX() Functions

The MIN() function returns the smallest value of the selected column.

The MAX() function returns the largest value of the selected column.

Let us see the syntax for each function below.

Syntax: MIN()

SELECT MIN(column_name)
  FROM table_name
  WHERE condition;

Syntax: MAX()

SELECT MAX(column_name)
  FROM table_name
  WHERE condition;

DB2 Database:

Below is a selection from the "Product" table in the DB2 database.

Example 1: Min Function

The following SQL statement finds the price of the cheapest product in the "Product" table.

SELECT MIN(Price) AS SmallestPrice
  FROM Products;

Result:

Example 2: Max Function

The following SQL statement finds the price of the most expensive product in the "Product" table.

SELECT MAX(Price) AS LargestPrice
  FROM Products;

Result:

If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!