AND and OR

Combine multiple conditions with AND and OR.

To combine conditions you use AND and OR. AND requires both conditions to hold; OR needs at least one to hold.

SELECT name FROM products
WHERE price > 10 AND stock > 0;

This returns products with price over 10 and stock over 0.

name is selected from products. WHERE keeps only the rows where price > 10 AND stock > 0 holds.

AND and OR — details

When AND and OR appear together, parentheses matter. AND is evaluated before OR; use parentheses to make the order explicit and safer.

For example, WHERE (city = 'İzmir' OR city = 'Bursa') AND active = 1 returns only active customers in those two cities thanks to the parentheses.

Select name from products where price is greater than 10 AND stock is greater than 0.

Show example solution

SELECT name
FROM products
WHERE price > 10 AND stock > 0

Join with AND

SELECT name FROM products
WHERE price > 10____stock > 0;

Show answer

SELECT name FROM products
WHERE price > 10 AND stock > 0;