I have a MySQL table with several columns, including one that contains numbers.
I can order this table and select the five lowest numbers using this command:
mysql_query("SELECT * FROM table ORDER BY number LIMIT 5");
However, say I want the five largest numbers, how do I do that?
In various searches I couldn't find anything about ordering numbers the opposite way, and in my various attempts I even tried with no avail:
mysql_query("SELECT * FROM table ORDER BY MAX(number) LIMIT 5");
Is there a way to do this?