Multiple choice

Find all employees in the database who do not work for State Bank of India.

  1. SELECT employee-name FROM employee WHERE employee-name IN (SELECT employee-name FROM employee-work WHERE company name = “State Bank of India”

  2. SELECT employee-name FROM employee WHERE employee-name except (SELECT employee-name FROM employee-work WHERE company name = “State Bank of India”

  3. SELECT employee-name FROM employee WHERE employee-name <> (SELECT employee-name FROM employee-work WHERE company name = “State Bank of India”

  4. SELECT employee-name FROM employee WHERE Employee-name not IN (SELECT employee-name FROM employee-work WHERE company name = “State Bank of India”
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This option is also incorrect which does not match with the correct query.

Keep practicing — related questions