MySQL reverse order without DESC

Question

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

Answer 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!