---
title: "How do you use the BETWEEN operator to filter results within a specified range in SQL?"  
description: "How do you use the BETWEEN operator to filter results within a specified range in SQL?"  
author: "Revati S Misra"  
published: 2023-07-04  
updated: 2023-07-05  
canonical: https://www.mindstick.com/forum/158945/how-do-you-use-the-between-operator-to-filter-results-within-a-specified-range-in-sql  
category: "mssql server"  
tags: ["mssql server", "sql server", "sql"]  
reading_time: 2 minutes  

---

# How do you use the BETWEEN operator to filter results within a specified range in SQL?

How do you use the BETWEEN [operator](https://www.mindstick.com/blog/144/union-intersection-and-except-operator-in-sql-server) to [filter results](https://www.mindstick.com/forum/158916/how-do-you-use-the-between-operator-in-sql-to-filter-results-based-on-a-range-of-values) within a [specified range](https://www.mindstick.com/forum/160084/describe-the-sql-between-operator-how-it-can-be-used-to-search-for-data-within-a-specified-range) in [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database)?

## Replies

### Reply by Aryan Kumar

The `BETWEEN` operator in SQL is used to [filter](https://www.mindstick.com/forum/1176/filter-in-a-xml-file-in-c-sharp) [results](https://yourviews.mindstick.com/story/4497/usage-of-baking-soda-magical-results) within a specified [range](https://www.mindstick.com/articles/23243/complete-troubleshooting-tips-for-belkin-n300-range-extender-setup). The `BETWEEN` operator takes two values, and returns all rows where the value of the column is between the two values.

The `BETWEEN` operator has the following syntax:

SQL

```plaintext
column_name BETWEEN value1 AND value2;
```

The `value1` and `value2` can be any expression, including literal values, column names, or function calls. The `value1` must be less than or equal to the `value2`.

Here is an example of how the `BETWEEN` operator can be used:

SQL

```plaintext
SELECT customer_name
FROM customers
WHERE age BETWEEN 18 AND 25;
```

This query will select the `customer_name` column from the `customers` table. The `BETWEEN` operator will be used to filter the results to only include customers who are between the ages of 18 and 25.

Here is another example of how the `BETWEEN` operator can be used:

SQL

```plaintext
SELECT product_name
FROM products
WHERE price BETWEEN 100 AND 200;
```

This query will select the `product_name` column from the `products` table. The `BETWEEN` operator will be used to filter the results to only include products that are priced between 100 and 200.

The `BETWEEN` operator can be used in a variety of ways to filter results within a specified range in SQL. It is a powerful tool that can be used to filter data, or to control the flow of a query.

Here are some other examples of how the `BETWEEN` operator can be used:

- To filter customers by their age.
- To filter products by their price.
- To filter orders by their date.
- To filter employees by their salary.

The `BETWEEN` operator is a versatile tool that can be used in a variety of ways to filter results within a specified range in SQL.


---

Original Source: https://www.mindstick.com/forum/158945/how-do-you-use-the-between-operator-to-filter-results-within-a-specified-range-in-sql

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.