SQL Between and Not Between Operators

Types of SQL Operators

SQL Arithmetic Operators

1. ADD
2. Subtract
3. Multiple
4. Divide
5. Modulo

SQL Bitwise Operators

1. And
2. OR
3. exclusive OR

SQL Comparison Operators

1. Equal to
2. Greater than
3. Less than
4. Greater than or Equal to
5. Less than or Equal to
6. Not equal to

SQL Logical Operators

1. All
2. And
3. Any
4. Between
5. Exists
6. In
7. Like
8. Not
9. OR
10. Some

SQL BETWEEN and NOT BETWEEN Operators

The BETWEEN operator is Logical operator.The BETWEEN operator selects records between minimum and maximum values. It returns TRUE if the operand is within the range of given values.The BETWEEN operator is used with where clause.

Syntax

SELECT
       [ID]
      ,[Category]
      ,[SubCategory]
      ,[Type]
      ,[Direction]
      ,[Model]
      ,[Side]
      ,[Supplier]
      ,[ItemCode]
      ,[ItemName]
      ,[PurchasePrice]
      ,[ReorderPoint]
      ,[OpeningStock]
      ,[Location]
      ,[MeasurementUnit]
  FROM tbl_ItemR

  where ID BETWEEN 1 and 10

Above SQL statement selects records the range of 1 and 10.The result is shown in Fig. below.

As you can see the record is between the given range of 1 and 10.



The NOT BETWEEN operator acts same as BETWEEN operator with slight difference.

Syntax

SELECT 
       [ID]
      ,[Category]
      ,[SubCategory]
      ,[Type]
      ,[Direction]
      ,[Model]
      ,[Side]
      ,[Supplier]
      ,[ItemCode]
      ,[ItemName]
      ,[PurchasePrice]
      ,[ReorderPoint]
      ,[OpeningStock]
      ,[Location]
      ,[MeasurementUnit]
  FROM tbl_ItemR

  where ID Not BETWEEN 1 and 360

Above SQL statement selects records the range of 1 and 10.The result is shown in Fig. below.
The difference is that NOT BETWEEN operator fetches record greater than the maximum value give,

As you can see that the record set starts from where ID is greater than 360.

For further question please mail: brainstormiert@gmail.com

SQL All Operator
SQL Any Operator
SQL And Operator