Why does the below statement return no rows selected as the result? - ProProfs Discuss
Advertisement

Why does the below 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);

Why does the below statement return no rows selected as the result?<br/>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); <br/>

Change Image    Delete

Asked by Karthicksugadev, Last updated: Nov 09, 2024

+ Answer
Request
Question menu
Vote up Vote down

1 Answer

karthicksugadev

karthicksugadev

karthicksugadev
Karthicksugadev

Answered Mar 15, 2018

.A NULL value is returned from the subquery.
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

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