- SQL Basics
- SQL Home
- SQL Syntax
- SQL RDBMS
- SQL Databases
- SQL Data Types
- SQL Operators
- SQL Expressions
- SQL Database
- SQL Create Database
- SQL Select Database
- SQL Drop Database
- SQL Table
- SQL Create Table
- SQL Drop Table
- SQL Keywords
- SQL Insert Into
- SQL Select
- SQL Where
- SQL And & Or
- SQL Update
- SQL Delete
- SQL Like
- SQL Select Top
- SQL Group By
- SQL Order By
- SQL Distinct
- SQL In
- SQL Between
- SQL Joins
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Constraints
- SQL Constraints
- SQL Unique
- SQL Not Null
- SQL Primary Key
- SQL Foreign Key
- SQL Check
- SQL Default
- SQL Create Index
- SQL Advance
- SQL Aliases
- SQL Union
- SQL Auto Increment
- SQL Views
- SQL Dates
- SQL Transactions
- SQL Injection
- SQL Test
- SQL Online Test
- Give Online Test
- All Test List
SQL Between
SQL BETWEEN operator is basically used to select the values within a range. The values can be text, numbers, or dates. Here is the general form of the BETWEEN operator in SQL:
SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;
SQL BETWEEN Operator Example
Here is an example of BETWEEN operator in SQL. Consider the following table CUSTOMERS having the records:
The following SQL statement selects all the columns of the table CUSTOMERS whose salary in between 76000 and 86000:
SELECT * FROM customers WHERE salary BETWEEN 76000 AND 86000;
After querying the above SQL statements, you will get the following output:
« Previous Tutorial Next Tutorial »
Like/Share Us on Facebook 😋