"Order by desc" in reverse order?

Question

Welcome,

I'm wondering is it possible to reverse returned data in sorting "order by desc" but i want that data in reverse order.

For example, i got table with values

ID
1
2
3
4

And i do

Order by ID ASC LIMIT 3 I got

1
2
3

When i do Order by ID DESC limit 3 i get

4
3
2

I would like to have

3
2
1

So i would like to order by ASC but revers results. I was always doing this in PHP side using array_reverse, but today i want ask You. Maybye i'm wrong and i can do this just in Mysql. Regards

Answer 1

SELECT * 
FROM (
  SELECT ... 
  FROM ... 
  ORDER BY ID ASC 
  LIMIT 3
) AS sq 
ORDER BY ID DESC

Think of it as working in two steps. First it executes the inner query: selects 3 records with lowest IDs. Then in the outer query it sorts them in descending order.

Answer 2

You can fetch the first three rows using a subquery and then reverse the order of these rows in an outer query:

SELECT *
FROM
(
    SELECT *
    FROM yourtable
    ORDER BY ID
    LIMIT 3
) T1
ORDER BY ID DESC