Skip to main content
MIN

Get the minimum value of a specified field within a range or partition

Updated over 2 weeks ago

Description

The MIN() function returns the minimum value of a specified field within a range or partition. This is useful for identifying the lowest value.

Syntax

MIN(arg)

Output

Varies based on input field type

Variables

  1. arg: the field to return the minimum value from.

Example

MIN(Value) Over (Partition by Group)

ID

Group

Value

MIN

1

A

10

10

2

A

20

10

3

A

15

10

4

B

30

30

5

B

40

30

Did this answer your question?