# MIN()

MIN() 函数返回指定列的最小值。

## MIN实例

从课程表 `courses` 查询最少的学生上课人数 `student_count`

```sql
SELECT MIN(student_count)
FROM courses;
```

执行输出结果

```bash
mysql> SELECT MIN(student_count)
    -> FROM courses;
+--------------------+
| MIN(student_count) |
+--------------------+
|                300 |
+--------------------+
1 row in set (0.02 sec)
```

## MIN总结

经过上面的实例，我们总结出MIN的一般使用方法

**语法**

```sql
SELECT MIN(column_name) FROM table_name;
```

## 练习题：MIN

题目描述：查询教师表 `teachers` 最小的教师年龄

```sql
SELECT MIN(age)
FROM teachers;
```

目标执行结果

```bash
mysql> SELECT MIN(age)
    -> FROM teachers;
+----------+
| MIN(age) |
+----------+
|       18 |
+----------+
1 row in set (0.01 sec)
```