Range operators are those operators which selects data according to particular range. There are two type of range operator and these are following:-
Between operator is used to select the data between any range.
select * from prod_rep where No_of_Prod between 1000 and 1200;
in this example it will select data between 1000 and 1200.
Note:-between operator include the range also. It means it will also select those data which contain 1000 and 1200.