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