在使用LIMIT后如何对结果进行排序？

Question

This is kind of straight forward. I want to ORDER BY date DESC Limit 4 and then I want to ORDER BY date ASC on that result, so just 4-games from the middle of the big table with ASC date order, any ideas? Just ORDER BY date ASC Limit 4 Does not work!

What I have:

What I get:

What I want:

Answer 1

you can use subquery :

SELECT a.* FROM (SELECT * FROM yourtable ORDER BY date DESC Limit 4) a ORDER BY a.Date