如何在MySQL中排序

Question

In the code below, I get the 9 latest objects in the table. Of this 9 objects, the last is presented as the latest. I wonder if it's possible to get the oppesite. Of this 9 objects, that the latest is the first in the result!? I hope my question isn't unclear!? It's hard to explain!

$query2 = "SELECT * from buildingObjects WHERE id > (SELECT MAX(id) - 9 FROM arkitekturobjekt)";
$result = $mysqli->query($query2);
while($row = $result->fetch_object()) {
// Show the objects here
}

Answer 1

If you are only interested in the last 9 IDs, listed last to first, you could simply do:

SELECT * FROM buildingObjects ORDER BY id DESC LIMIT 9