对于降序结果,请使用DESC。但是,LIMIT用于获取固定数量的记录-select *from yourTableName order by yourColumnName DESC LIMIT yourLimitNumber;
让我们首先创建一个表-create table DemoTable (Id int, Name varchar(100));
示例
使用插入命令在表中插入一些记录-insert into DemoTable values(100,'John');
insert into DemoTable values(101,'Chris');
insert into DemoTable values(102,'Robert');
insert into DemoTable values(103,'Bob');
insert into DemoTable values(104,'Adam');
insert into DemoTable values(105,'James');
使用select语句显示表中的所有记录-select *from DemoTable;
输出结果+------+--------+
| Id | Name |
+------+--------+
| 100 | John |
| 101 | Chris |
| 102 | Robert |
| 103 | Bob |
| 104 | Adam |
| 105 | James |
+------+--------+
6 rows in set (0.00 sec)
以降序获取固定数量的记录-select *from DemoTable order by Name DESC LIMIT 3;
输出结果+------+--------+
| Id | Name |
+------+--------+
| 102 | Robert |
| 100 | John |
| 105 | James |
+------+--------+
3 rows in set (0.00 sec)