Between Operator: The between operator work in specific column value range between two range of values. This operator is Varey important in SQL. When we find some range of value after when condition then we use the between operator for find the values of specific range. Now given bellow the example code of the between operator:
select * from Salary where Salary.Id Between 1 and 4
in this code we find the id 1 to 4 range of the value by using salary table and Id column.