# min

Get the minimum value in a group

## Signature

> MIN(colName)

## Usage Examples

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

```sql
select min(yearID) AS value
from baseballStats 
```

| value |
| ----- |
| 1871  |