Between operation:-

  • 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’