Lektion 6 af 9
ORDER BY og LIMIT
ORDER BY sorterer resultater. Brug ASC til stigende og DESC til faldende. LIMIT begrænser antallet af returnerede rækker.
SQL
-- Sort by price lowest to highest
SELECT * FROM products ORDER BY price ASC;
-- Sort by newest first
SELECT * FROM orders ORDER BY created_at DESC;
-- Get top 5 most expensive
SELECT * FROM products ORDER BY price DESC LIMIT 5;