How to test range of specified data by using then BETWEEN operator?

The BETWEEN operator is used to specify a range of data you want to test your result set against. The BETWEEN operator is frequently used with the WHERE clause and any of the following statements:

• SELECT statement;
• INSERT statement;
• UPDATE statement;
• DELETE statement.

The following example shows a basic syntax using BETWEEN operator:

Syntax

SELECT|INSERT|UPDATE|DELETE * WHERE (NOT) BETWEEN begin_expression AND end_expression;

A simple real world example, than, would look like this:

SELECT * FROM Emp WHERE salary BETWEEN 10000 AND 20000;

Obviously, this query will list all the employees having salary from 10000 to 20000. The * is a wildcard for everything.