Qo‘llanma · SQL
limit
1 ta masala Masalalar ro‘yxatida
Nazariya
LIMIT natijadan faqat dastlabki n qatorni qoldiradi. Deyarli doim ORDER BY bilan birga ishlatiladi.
SELECT name, price FROM products ORDER BY price DESC LIMIT 3; -- eng qimmat 3 ta
SELECT name FROM students ORDER BY id LIMIT 10 OFFSET 20; -- 21–30-qatorlar
Diqqat
«Eng katta» chegarada teng qiymatlar bo‘lsa, LIMIT ulardan birini tasodifiy kesib tashlaydi.
Masala tenglarni ham so‘rasa, ichki so‘rov ishlating: WHERE price = (SELECT MAX(price) FROM products).
Beginner
- Beginner