ROUND

The ROUND function rounds the supplied number to the nearest integer.

Usage

ROUND(number) : integer

Example

The example query adds a calculated column with the numbered rounded.

gorrow chr1,1,1 | CALC test round(4.5)

chrom    bpStart bpStop test
chr1     1       1      5