mysql 反向排序,没有DESC的MySQL反向顺序

SELECT id FROM table LIMIT 8, 3

results in 8,9,10

but I need 10,9,8

How can you do this? If you add "ORDER BY id DESC" it gets 3,2,1

解决方案

Put your query in a subselect and then reverse the order in the outer select:

SELECT id from (

SELECT id FROM table ORDER BY id LIMIT 8, 3

) AS T1 ORDER BY id DESC

Test data:

CREATE TABLE table1 (id INT NOT NULL);

INSERT INTO table1 (id) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11);

SELECT id from (

SELECT id FROM table1 ORDER BY id LIMIT 8, 3

) AS T1 ORDER BY id DESC

Result:

10

9

8

Note that the ORDER BY in the subquery is required otherwise the order is undefined. Thanks to Lasse for pointing this out!