between keyword in sql

1/*the BETWEEN operator is used to filter the result set within 
2a certain range. the values can be numbers, texts or dates */
3SELECT column_name(s)
4FROM table_name
5WHERE column_name BETWEEN value1 AND value2;

1SELECT column_name(s)
2FROM table_name
3WHERE column_name BETWEEN value1 AND value2;

1Select * From employees
2Where salary >= 4000
3And salary  <= 6000;
4
5We can also use between
6
7Select * From employees
8Where salary BETWEEN 4000 AND 6000;

1(Between) operator same as  ">= <="
2For example: 
3Select * From Employees Where salary Between 4000 AND 6000;
4