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.

Example of Range Operator

		
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.

The output of this query is as follows:-

		
between operator

		Figure 1
		
		

Not Between

Not between operator works opposite the between. It will select all data except those which will be not in given range.

		
select * from prod_rep where No_of_Prod not between 1000 and 1200;
		
		

The output of this query is as follows:-

		
Not between operator

		Figure 1

		

It selects all data which does not fall in this range which is 1000 to 1200

Email Address

For any query you can send mail at info@techaltum.com
Thanks