Learn SQL
BETWEEN & NOT BETWEEN
7.5
Lesson

Select using NOT BETWEEN

Find all students who don’t have marks between 30 and 70.

One way of doing this would be using WHERE in combination with less than and greater than operators.

A nicer way of doing it is by using NOT BETWEEN.

We can see that NOT BETWEEN serves the exact opposite purpose of what BETWEEN serves.