where

WHERE faqat shartga mos qatorlarni qoldiradi.

SELECT name FROM students WHERE city = 'Toshkent';
SELECT * FROM products WHERE price BETWEEN 1000 AND 5000;
SELECT * FROM students WHERE grade >= 4 AND city <> 'Samarqand';
SELECT * FROM orders WHERE status IN ('new', 'paid');

Diqqat

• Satrlar bitta qo‘shtirnoqda: 'Toshkent'.
• AND OR dan oldin bajariladi — aralash shartlarni qavsga oling: (a OR b) AND c.
• NULL bilan = ishlamaydi: IS NULL / IS NOT NULL ishlating.