Built-In Functions and Syntax › Minimum

Minimum

The minimum function returns the lowest value in the specified column for all occurrences with the same GROUP BY value.

Syntax:

►►─┬─ MIN ─────┬─ (value) ────────────────────────────────────────────────────►◄
   ├─ MINIMUM ─┤
   ├─ LOV ─────┤
   └─ LOVAL ───┘

Invocation names:

MIN       LOV
MINIMUM   LOVAL

Parameters:

(value)

The column or expression for which the minimum value is calculated.

Example:

This example calculates the lowest salary in each department.

select min(salary) as 'low salary' from employee

  LOW SALARY = '17000'