The ultimate test of your knowledge is your capacity to convey it. - Richard Feynman
© 2020. All Rights Reserved.
In MariaDB, query with ORDER BY in a FROM subquery produces an unordered result. In effect, ORDER BY is ignored in FROM subqueries. MySQL does not ignore ORDER BY in FROM subqueries.