mysql> SELECT * FROM sales_fig ORDER BY productID DESC LIMIT 10; +------------------------------------------+-----------+--------+ | product | productID | sales | +------------------------------------------+-----------+--------+ | Gazellentofu (vegan, mit Vit. A) | 9987 | 532.7 | | Pochierte Wasserfloehe an Gruenalgen | 6547 | 1298.5 | | Spicy Spinnenbein (ohne Fett) | 5211 | 432.6 | | Antipasti vom Aas | 4321 | 300 | | Maeuseschinken aus dem Wacholderrauch | 3321 | 889.5 | | Aromaheu "Sommerglueck" | 3003 | 776.1 | | Schmetterlingskraftfutter "Power Pollen" | 2017 | 399.6 | | Grashuepferhaxe, trad. bayr. | 1001 | 646.8 | | Silage-Sorbet | 113 | 411.3 | | Junge Regenwuermer (Meterware) | 18 | 461.4 | +------------------------------------------+-----------+--------+ 10 rows in set (0,00 sec)