Consider the following SQL query, which is intended to return employees who are not managers: SELECT * FROM Employee WHERE ID NOT IN (SELECT ManagerID FROM Employee); What will happen if the ManagerID column contains NULL values?

Crowdly

Add to Chrome

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Consider the following SQL query, which is intended to return employees who are not managers:

<SQL>

SELECT *

FROM Employee
WHERE ID NOT IN (SELECT ManagerID FROM Employee);

What will happen if the ManagerID column contains NULL values?

The query works correctly

The query ignores NULL values

The query returns an empty set

100%

The query returns all rows

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome