让我们首先创建一个表-mysql> create table DemoTable
(
Name varchar(100),
Age int
);
使用插入命令在表中插入一些记录-mysql> insert into DemoTable values('Chris',23);
mysql> insert into DemoTable values('David',55);
mysql> insert into DemoTable values('Bob',53);
mysql> insert into DemoTable values('Mike',54);
mysql> insert into DemoTable values('Sam',55);
使用select语句显示表中的所有记录-mysql> select *from DemoTable;
这将产生以下输出-+-------+------+
| Name | Age |
+-------+------+
| Chris | 23 |
| David | 55 |
| Bob | 53 |
| Mike | 54 |
| Sam | 55 |
+-------+------+
5 rows in set (0.00 sec)
以下是查询以选择具有最大年龄值的所有用户-mysql> select *from DemoTable
where Age=(select max(Age) from DemoTable);
这将产生以下输出-+-------+------+
| Name | Age |
+-------+------+
| David | 55 |
| Sam | 55 |
+-------+------+
2 rows in set (0.00 sec)