> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for MIN function

# MIN OVER

Returns the minimum value within the requested window.

For more information on usage, please refer to [Window Functions](/reference-sql/functions-reference/window).

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
MIN( <expression> ) OVER ( [ PARTITION BY <partition_by> ] )
```

## Parameters

| Parameter        | Description                                       | Supported input types |
| :--------------- | :------------------------------------------------ | :-------------------- |
| `<expression>`   | A value used for the `MIN` function               | Any                   |
| `<partition_by>` | An expression used for the `PARTITION BY` clause. | Any                   |

## Example

The example below queries test scores for players in various grade levels. Unlike a regular `MIN()` aggregation, the window function highlights how each player individually compares to the lowest game score for their level.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	nickname,
	level,
	current_score,
	MIN(current_score) OVER (PARTITION BY level) AS lowest_score
FROM
	players;
```

**Returns**:

| nickname    | level | current\_score | lowest\_score |
| :---------- | :---- | :------------- | :------------ |
| kennethpark | 9     | 76             | 2             |
| sabrina21   | 7     | 90             | 15            |
| burchdenise | 5     | 79             | 4             |
| ymatthews   | 6     | 85             | 9             |
| rileyjon    | 8     | 80             | 20            |