Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When reading data from the database with Between Operator, we can specify a range for the data we filter in WHERE Clause. Let’s make an example for a better understanding of the subject.
Example:
First, let’s create a table as below and add a few records.
1 2 3 4 5 6 7 8 9 | USE [TestDB] GO CREATE TABLE [dbo].[MyTable]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NOT NULL, [Age] int NOT NULL ) ON [PRIMARY] GO INSERT INTO [dbo].[MyTable] VALUES ('Nurullah',34),('Faruk',27),('Hakan',36),('Ogun',27) |
List the people aged 30 to 40 years old:
1 | SELECT * From [dbo].[MyTable] WHERE Age Between 30 AND 40 |
List the people whose names are between N and P:
1 | SELECT * From [dbo].[MyTable] WHERE Name Between 'N' AND 'P' |
List the people whose names are not between N and P:
1 | SELECT * From [dbo].[MyTable] WHERE Name NOT Between 'N' AND 'P' |
