Major Description
create table test_1009(id int);
insert into table test_1009 values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13);
select * from (select * from test_1009 order by id desc) a limit 10;
-------
| a.id |
-------
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
–
-----------------------
the right result should be
-------
| a.id |
-------
| 13 |
| 12 |
| 11 |
| 10 |
| 9 |
| 8 |
| 7 |
| 6 |
| 5 |
| 4 |
-------