# MINMAXRANGEMV

Returns the max - min value in a group

## Signature

> MINMAXRANGEMV(colName)

## Usage Examples

These examples are based on the [Hybrid Quick Start](https://docs.pinot.apache.org/release-0.11.0/basics/getting-started/quick-start#hybrid).

```sql
select MINMAXRANGEMV(DivLongestGTimes) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1
```

| value |
| ----- |
| 106   |