Operator: NOT IN  <>

:select dname, loc from dept where loc <> 'CHICAGO'

 

 
Oracle:

PostgreSQL