---
title: "BETWEEN CONDITION IN SQLSERVER"  
description: "BETWEEN CONDITION IN SQLSERVER"  
author: "Anonymous User"  
published: 2015-12-15  
updated: 2015-12-15  
canonical: https://www.mindstick.com/forum/33737/between-condition-in-sqlserver  
category: "database"  
tags: ["sql server", "sql", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# BETWEEN CONDITION IN SQLSERVER

I want to use BETWEEN [CONDITION](https://www.mindstick.com/forum/12711/select-query-with-and-condition) in Sqlserver. please help me.

## Replies

### Reply by Anonymous User

The SQL Server (Transact-SQL) BETWEEN condition is used to retrieve values within a range in a SELECT, INSERT, UPDATE, or DELETE statement.

```
SELECT *FROM EmployeeWHERE Emp_ID  BETWEEN 15 AND 25;
```

![BETWEEN CONDITION IN SQLSERVER](https://www.mindstick.com/mindstickforums/f2fa41e0-7538-404c-80cd-5f2d93e30118/images/cc9c80ad-dc96-45bd-beea-fb390496ab76.png)


---

Original Source: https://www.mindstick.com/forum/33737/between-condition-in-sqlserver

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