# DISTINCT

Returns the distinct row values in a group

## Signature

> DISTINCT(colName)

## Usage Examples

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

```sql
select DISTINCT league AS value
from baseballStats 
```

| value |
| ----- |
| NL    |
| UA    |
| AL    |
| NA    |
| PL    |
| AA    |
| FL    |

```sql
select DISTINCT(league) AS value
from baseballStats 
```

| value |
| ----- |
| NL    |
| UA    |
| AL    |
| NA    |
| PL    |
| AA    |
| FL    |