Lección 6 de 9
ORDER BY y LIMIT
ORDER BY ordena resultados. Usa ASC para ascendente y DESC para descendente. LIMIT restringe cuántas filas se devuelven.
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;