versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/min.md

---
{
    "title": "MIN",
    "language": "en",
    "description": "The MIN function returns the minimum value of the expression."
}
---

## Description

The MIN function returns the minimum value of the expression.

## Syntax

```sql
MIN(expr)
```

## Parameters

| Parameters | Description |
| -- | -- |
| `<expr>` | The expression needs to be obtained |

## Return Value

Returns the same data type as the input expression.

## Example

```sql
select MIN(scan_rows) from log_statis group by datetime;
```

```text
+------------------+
| MIN(`scan_rows`) |
+------------------+
|                0 |
+------------------+
```