Multiple choice

Which SQL statement will give different output as compared to others in oracle database?

  1. Select * from emp where not Job = 'Manager';

  2. Select * from emp where Job != 'Manager;

  3. Select * from emp where Job <> 'Manager';

  4. Select * from emp where Job not in ('Manager');

  5. Select * from emp where Job in ('Manager');
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

This will give all data of emp table only where Job is Manager.

Keep practicing — related questions