SQL Between

SQL BETWEEN 

In this tutorial, you will learn how to use SQL Between operator in SQL Server

The SQL BETWEEN operator is a logical operator that allows to fetched the certain range in the specified table.

  
SELECT 
  column_name
FROM
  table_name
WHERE 
  column_name BETWEEN Start_value AND End_value;
  
  

• First, use the select keyword and specify the column name or use * get full table data. 
• second, mention the table name and place the start_value and End_value between the Between keyword have the same data type.
• Here, the condition that is using Between operator that uses the operators >=, <=, AND, IN. 
• AND used Between operator, not Between operator.

we already create the student table from the sample database

 

student table	id (primary key),	student_name,	class,	age,	phone_no,

BETWEEN

 
  
SELECT 
  student_name,
  class,
  age 
FROM
  student 
WHERE age BETWEEN 15 and 16;  
  
  

---

NOT BETWEEN

  
  
SELECT 
  student_name,
  class,
  age 
FROM 
  student 
where age NOT BETWEEN 15 and 16;
  
  

---

BETWEEN ORDER BY

 
  
SELECT 
     * 
FROM
   student 
WHERE
   age BETWEEN 15 AND 16 
ORDER BY 
   student_name;  
  
  

---

NOT BETWEEN ORDER BY

  
  
SELECT 
    * 
FROM 
   student 
WHERE
   age NOT between 15 and 16 
ORDER BY 
   student_name;
  
  
  

---

BETWEEN NOT IN

  
  
SELECT 
   * 
FROM 
   student 
WHERE 
   age BETWEEN 15 AND 17  
AND id NOT IN (101,108); 
  
  

---