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:-
Between operator is used to select the data between any
range.
For example:-
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.
