A few times to sort the output in mysql single query?

I need to get the last 5 records based on the date the request:
SELECT * FROM news ORDER BY date DESC LIMIT 5

The resulting output you want to sort in reverse order by id. As the news kept date 2020-02-18 if I use the above query, I get the following output: Новость1, Новость2, Новость3.... these news have the same date. And I need to get them in reverse order.
How to do it 1 query, or maybe there is another solution?

For example, there is a solution to use the date time, then 1 request all solved, but this is not my case.
April 7th 20 at 15:36
3 answers
April 7th 20 at 15:38
Solution
SELECT * FROM news ORDER BY date DESC, id DESC LIMIT 5
April 7th 20 at 15:40
If I understand you correctly, try this:
SELECT *
FROM (
SELECT * FROM news ORDER BY date DESC LIMIT 5
) as t
ORDER BY id;
in this case, means as t? - davonte_Nolan74 commented on April 7th 20 at 15:43
Is alias, alias. You need to define the output of this select:
SELECT * FROM news ORDER BY date DESC LIMIT 5

But in General this is all one request:
SELECT *
FROM (
SELECT * FROM news ORDER BY date DESC LIMIT 5
) as t
ORDER BY id;
- kamille91 commented on April 7th 20 at 15:46
April 7th 20 at 15:42
SELECT t1.* FROM news t1
LEFT JOIN (SELECT t2, id FROM news ORDER BY created_at DESC LIMIT 5) t1 ON t3.id = t3.id
ORDER BY t1.id

Find more questions by tags MySQL