Why does the above statement return no rows selected as the result? - ProProfs Discuss
Topics
Products
Follow Us:

Why does the above statement return no rows selected as the result? Mr. King is the president of a company. Five managers report to him. All other employees report to these managers. Examine the code: SELECT employee.ename FROM emp employee WHERE employee.empno NOT IN (SELECT manager.mgr FROM emp manager);



A. NOT IN operator is not allowed in subqueries.
B. All employees have a manager.
C. None of the employees has a manager.
D. A NULL value is returned from the subquery.

This question is part of ORACLE SQL
Asked by Karthicksugadev, Last updated: Jan 11, 2020

+ Answer
Request

1 Answer

karthicksugadev

Karthicksugadev

Answered Mar 15, 2018

.A NULL value is returned from the subquery.
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.