Objective : NOT IN operation filtering job other than clerk and sales man.

SELECT * FROM emp WHERE job NOT IN ('CLERK','ANALYST')

 
Oracle:


PostgreSQL