MySQL 如何找到一列中的最高数

您可以利用聚合函数 MAX 来找到一列中的最高数。语法如下−

select max(yourColumnName) as anyVariableName from yourTableName;

为了理解上述概念，让我们创建一个带有 int 列的表。以下是创建表的查询。

mysql> create table HighestNumberDemo
   −> (
      −> BigNumber int
   −> );
Query OK, 0 rows affected (0.87 sec)

现在在表中插入一些值。插入记录的查询如下−

mysql> insert into HighestNumberDemo values(1234);
Query OK, 1 row affected (0.43 sec)

mysql> insert into HighestNumberDemo values(9999);
Query OK, 1 row affected (0.18 sec)

mysql> insert into HighestNumberDemo values(10000);
Query OK, 1 row affected (0.17 sec)

mysql> insert into HighestNumberDemo values(989898);
Query OK, 1 row affected (0.14 sec)

mysql> insert into HighestNumberDemo values(999987);
Query OK, 1 row affected (0.18 sec)

现在，您可以利用 select 语句显示所有记录。显示所有记录的查询如下−

mysql> select *from HighestNumberDemo;

以下是输出结果−

+-----------+
| BigNumber |
+-----------+
|      1234 |
|      9999 |
|     10000 |
|    989898 |
|    999987 |
+-----------+
5 rows in set (0.00 sec)

按照我们上面讨论的语法来寻找一列中的最高数。查询如下−

mysql> select max(BigNumber) as HighestNumber from HighestNumberDemo;

以下是输出结果−

+---------------+
| HighestNumber |
+---------------+
| 999987        |
+---------------+
1 row in set (0.00 sec)

阅读更多：MySQL 教程