Logical operators

Learn AND, OR, NOT logical operators.

Comparison operators

=, <>, <, >, <=, >= are comparison operators. They compare a column with a constant in a condition.

SELECT name FROM products WHERE price >= 50;

This query products with price 50 or more.

name is selected from products. WHERE keeps only the rows where price >= 50 holds.

For not-equal use <> or !=. ANSI SQL prefers <>. Text comparison uses the same operators.

Select names from products where price is greater than or equal to 50.

Show example solution

SELECT name
FROM products
WHERE price >= 50

Greater or equal

SELECT name FROM products WHERE price ____ 50;

Show answer

SELECT name FROM products WHERE price >= 50;

Next lesson: IS NULL