This operator is used to get the data from a combination of " greater than equal " and " less than equal " condition .
Syntax :

select column_name1.......column_nameN from table_name where column_name between value1 and value2 ;

Example :
Table name : Employee_Info

  Id        Employee_name          Employee_Age         Employee _Salary     City 
  1            Mukesh                  23                  100000            Meerut
  2            Ayush                   24                  200000            Baroda
  3            Ishan                   40                  400000            Multan
  4            Pranav                  35                  123,00000         Dehradun
  5            Abhishek                26                  800000            Mussoorie
  6            Ravi                    25                  300000           Pauri-Garhwal
  7            David                   40                  8000              Baghpat

Query :

select * from Employee_Info where Employee_Salary between 200000 and 100000 ;

Output :

Id        Employee_name          Employee_Age         Employee _Salary      City
 3            Ishan                   40                  400000            Multan
 5            Abhishek                26                  800000            Mussoorie
 6            Ravi                    25                  300000           Pauri-Garhwal