WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

SQL BETWEEN Operator


The BETWEEN administrator is utilized to choose esteems inside a range.


The SQL BETWEEN Operator

The BETWEEN administrator chooses values inside a range. The qualities can be numbers, content, or dates.

SQL BETWEEN Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Database

In this instructional exercise we will utilize the database.

Below is a choice from the "Physical" table:

PhysicalID FirstName Height Weight Blood type
1 Sandra Bayer 161 centimeters 94.3 kilograms B+
2 Anja Eichmann 170 centimeters 93.0 kilograms O+
3 Thomas Luft 163 centimeters 83.0 kilograms O+
4 Benjamin Kruger 181 centimeters 94.9 kilograms A-
5 Mathias Kuhn 176 centimeters 80.6 kilograms B+

BETWEEN Operator Example

The following SQL explanation chooses all items with a Blood type BETWEEN An and O:

Example

SELECT * FROM Physical
WHERE Blood type BETWEEN An AND O;


NOT BETWEEN Operator Example

To show the items outside the scope of the past precedent, use NOT BETWEEN:

Example

SELECT * FROM Physical
WHERE Blood type NOT BETWEEN An AND O;


BETWEEN Operator with IN Example

The following SQL proclamation chooses all Physical with a Blood type BETWEEN An and O, however items with a PhysicalID of 1,2, or 3 ought not be displayed:

Example

SELECT * FROM Physical
WHERE (Blood type BETWEEN An AND O)
AND NOT PhysicalID IN (1,2,3);


BETWEEN Operator with Text Value Example

The following SQL articulation chooses all Physical with a FirstName starting with any of the letter BETWEEN 'C' and 'M':

Example

SELECT * FROM Products
WHERE ProductName BETWEEN 'C' AND 'M';


NOT BETWEEN Operator with Text Value Example

The following SQL explanation chooses all items with a ProductName starting with any of the letter NOT BETWEEN 'C' and 'M':

Example

SELECT * FROM Products
WHERE ProductName NOT BETWEEN 'C' AND 'M';


Sample Table

Below is a determination from the "Orders" table:

OrderID CustomerID EmployeeID OrderDate ShipperID
10248 90 5 7/4/1996 3
10249 81 6 7/5/1996 1
10250 34 4 7/8/1996 2
10251 84 3 7/9/1996 1
10252 76 4 7/10/1996 2

BETWEEN Operator with Date Value Example

The following SQL explanation chooses all requests with an OrderDate BETWEEN '04-July-1996' and '09-July-1996':

Example

SELECT * FROM Orders
WHERE OrderDate BETWEEN #07/04/1996# AND #07/09/1996#;