ANY == SOME == IN

select DEPARTMENT_ID, SALARY 

from EMPLOYEES

where salary = any(2000,3000,4000)

order by EMPLOYEE_ID; 

select DEPARTMENT_ID, SALARY 

from EMPLOYEES

where salary = some(2000,3000,4000)

order by EMPLOYEE_ID; 

select DEPARTMENT_ID, SALARY 

from EMPLOYEES

where salary in(2000,3000,4000)

order by EMPLOYEE_ID;