- Between operation is used to compare column Value with range of values [it includes lower & upper values]
Syntax:-Between v1 and v2 (or) Not between v1 and v2.
Example:-Select * from emp Where sal between 2000 and 5000
Note: – Between operator always works with lower limit & Upper limit but not upper limit & lower limit.
Display employee records working as clerk (or) manager
Select * from emp Where job=’clerk’ on job=’manager’