要按从最高到最低的顺序排序,可以使用ORDER BY DESC命令-select *from yourTableName order by yourColumnName DESC;
如果您希望结果从最低到最高,可以使用ORDER BY ASC命令-select *from yourTableName order by yourColumnName ASC;
让我们首先创建一个表-mysql> create table DemoTable
(
Value int
);
使用插入命令在表中插入记录-mysql> insert into DemoTable values(134);
mysql> insert into DemoTable values(245);
mysql> insert into DemoTable values(451);
mysql> insert into DemoTable values(1090);
mysql> insert into DemoTable values(789);
mysql> insert into DemoTable values(434);
使用选择命令显示表中的记录-mysql> select *from DemoTable;
这将产生以下输出-+-------+
| Value |
+-------+
| 134 |
| 245 |
| 451 |
| 1090 |
| 789 |
| 434 |
+-------+
6 rows in set (0.00 sec)
情况1-按从最高到最低的顺序排列-mysql> select *from DemoTable order by Value DESC;
这将产生以下输出-+-------+
| Value |
+-------+
| 1090 |
| 789 |
| 451 |
| 434 |
| 245 |
| 134 |
+-------+
6 rows in set (0.07 sec)
情况2-按从最低到最高的顺序排列-mysql> select *from DemoTable order by Value ASC;
这将产生以下输出-+-------+
| Value |
+-------+
| 134 |
| 245 |
| 434 |
| 451 |
| 789 |
| 1090 |
+-------+
6 rows in set (0.00 sec)