The MIN function compares two numbers and returns the minimum of the two. The supplied numbers can be references to columns.


MIN(number,number) : float


The example query here explicitly lists two numbers (4 and 5) and creates a calculated column called “test” with the minimum number (4).

gorrow chr1,1,1 | CALC test min(4,5)
chrom    bpStart bpStop test
chr1     1       1      4

The next query creates two columns (number1 and number2) with random numbers and then compares and writes the lower number in the test column.

gorrow chr1,1,1 | CALC number1 random() | CALC number2 random() | CALC test min(number1,number2)

The following query contains nested MIN functions to show how you might want to compare three different numbers.

gorrow chr1,1,1 | CALC test min(4,min(3,5))
chrom    bpStart bpStop test
chr1     1       1      3