Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

MIN

Syntax

MIN ( { [ALL] expression } | { DISTINCT column_ref } )

Description

The aggregate function MIN returns the minimum value in a group of values.

  • The specification of DISTINCT has no effect on the result.
  • The argument column_ref or expression can be of any type.
  • The result of the function is of the same data type as that of the argument.
  • The result is null if the result set is empty or contains only null values.

Example

SELECT MIN (salary)

FROM employee

WHERE deptno = 20 ;

TOCIndex