SQL · Reading data

comparison operators

Compare values. Use IS NULL and IS NOT NULL for null checks, never = NULL.

sqlRunnable example sql course

Syntax

= <> < > <= >=

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (12), (18))
SELECT minutes FROM lessons WHERE minutes <> 12;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.