Hi,
BETWEEN operator: This operator is specially used to work with numeric data. BETWEEN operator select the values from particular range of values.
Ex. SELECT column_name(s)
FROM table_name
WHERE columnname BETWEEN value1 AND value2;
IN operator: In operator is a logical operator which uses to check that particular values exists or not in set of values.
Ex.
SELECT column_list FROM table
WHERE columnname IN (values1, values2, values3...);
The main difference between these two operators are In operator allows to check specific value from multiple data and BETWEEN operator used to select multiple (range) of data.
|