SQL BETWEEN Statement

SQL BETWEEN returns values between a given range.
SQL NOT BETWEEN returns values that are outside a given range.
Instead of BETWEEN you can use >= and <=, but it will make your query longer.
Let us look at examples to make this clear.

Imagine we have table called CUSTOMERS, with the following data:

Rambo

Robert

Belgium

Mugambo

Satraj

Norway

Nagashekar

Rao

India

Tom

Harry

Brazil

Dana

Laura

Australia

Rambo

Fox

New Zealand

Giselle

Chivvi

Japan

Scenario 1: Get me all records where Customer's Age is between 22 to 50. We can use a BETWEEN Clause to specify the above criteria.

SELECT * from Customer WHERE AGE BETWEEN (22, 50)

Result:

Rambo

Robert

Belgium

Mugambo

Satraj

Norway

Nagashekar

Rao

India

Tom

Harry

Brazil

In the above WHERE Clause, we used BETWEEN Condition to display only the Customers who's age is between 22 and 50.

Scenario 2: Get me all records where Customer's Age is NOT between 22 and 50. We can use a NOT BETWEEN Clause to specify the above criteria.

SELECT * from Customer WHERE AGE NOT BETWEEN (22, 50)

Result:

Dana

Laura

Australia

Rambo

Fox

New Zealand

Giselle

Chivvi

Japan

In the above WHERE Clause, we used NOT BETWEEN Condition to display only the Customers who's age is outside the range of 22 and 50.