SELECT MIN(column_name) FROM table_name;
在本教程中,我们将使用 RUNOOB 样本数据库。
下面是选自 "Websites" 表的数据:
+----+--------------+---------------------------+-------+---------+
+----+--------------+---------------------------+-------+---------+
<table>
<tr>
<th>1</th>
<th>Google</th>
<th>https://www.google.cm/</th>
<th>1</th>
<th>USA</th>
</tr>
<tr>
<td>3</td>
<td>菜鸟教程</td>
<td>http://www.runoob.com/</td>
<td>4689</td>
<td>CN</td>
</tr>
<tr>
<td>4</td>
<td>微博</td>
<td>http://weibo.com/</td>
<td>20</td>
<td>CN</td>
</tr>
<tr>
<td>5</td>
<td>Facebook</td>
<td>https://www.facebook.com/</td>
<td>3</td>
<td>USA</td>
</tr>
<tr>
<td>6</td>
<td>百度</td>
<td>https://www.baidu.com/</td>
<td>4</td>
<td>CN</td>
</tr>
<tr>
<td>7</td>
<td>stackoverflow</td>
<td>http://stackoverflow.com/</td>
<td>0</td>
<td>IND</td>
</tr>
</table>
+----+---------------+---------------------------+-------+---------+
下面的 SQL 语句从 "Websites" 表的 "alexa" 列获取最小值:
SELECT MIN(alexa) AS min_alexa FROM Websites;
执行以上 SQL 结果如下所示:
![](https://www.runoob.com/wp-content/uploads/2013/09/min1.jpg]
来源:https://www.runoob.com/sql/sql-func-max.html