درس 6 من 9
ORDER BY و LIMIT
ORDER BY يرتب النتائج. استخدم ASC للترتيب التصاعدي و DESC للتنازلي. LIMIT يحدد عدد الصفوف التي ترجعها query.
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;