MIN

Learn how to use the MIN aggregate function in PlaidCloud Lakehouse. Returns the minimum value in a set of values - see syntax, examples, and output.

Returns the minimum value in a set of values.

Analyze Syntax

func.min(get_column(table, 'salary'))

Analyze Examples

func.min(get_column(table, 'salary'))

┌───────┐
 35000 
└───────┘

SQL Syntax

MIN(<salary>)

SQL Examples

SELECT MIN(salary) FROM employees;

┌───────┐
 35000 
└───────┘