Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Built-in Functions/ Aggregate Functions/ min
Updated on 2023-10-25 GMT+08:00
View PDF

min

This function is used to return the minimum value.

Syntax

min(col)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

col

Yes

Any type except BOOLEAN

The value can be of any type except BOOLEAN.

Return Values

The return value is of the DOUBLE type.

The return type is the same as the type of col. The return rules are as follows:

  • If the value of col is NULL, the row is not involved in calculation.
  • If the value of col is of the BOOLEAN type, it cannot be used for calculation.

Example Code

  • Calculates the minimum inventory (items) of all offerings. An example command is as follows: 
    select min(items) from warehouse;

    The command output is as follows:

    _c0        
600
  • When used with group by, it returns the minimum inventory of each warehouse. An example command is as follows: 
    select warehourseId, min(items) from warehouse group by warehourseId;

    The command output is as follows:

    warehouseId _c1        
city1      15         
city2      10         
city3      19
Parent topic: Aggregate Functions