Between keyword search data from table in rage of two values, It requires two values that is from value and to value. We use AND operator to separates two values.
Let consider below list of shopping items, and we are going to apply BETWEEN keyword in this table.
Select the product from Shopping table where product price between range of 15000 and 25000.
Example
Output
Select the product from Shopping table where product price not between range of 15000 and 25000.
Example
Output
Note : What is difference between IN and BETWEEN?
IN : IN keyword filter the data from given values.
BETWEEN : BETWEEN keyword filter the select data from range of two values.