How To Use BETWEEN Operator In SQL

In this article, we will learn how to use the BETWEEN operator with a SQL select query.

The BETWEEN operator is used to select values within a given range, begin and end values are also included in that. The values can be numbers, strings, or dates.

Syntax

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

Example-1

The subsequent statement would return all articles with an ID BETWEEN 3 AND 7.

SELECT * FROM Article
WHERE ID BETWEEN 3 AND 7;

Example-2

The subsequent statement would return all articles without an ID BETWEEN 3 AND 7.

SELECT * FROM Article 
WHERE ID NOT BETWEEN 3 AND 7;

Also, check How To Use IN, NOT IN Operator In SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.