An SQL statement to display the first name of the employees who is a department manager and has no dependent registered in the company database can be

Question

Answer

None of these

Answer

select fname from employee, department where mgr_ssn=ssn and where not exists (select * from dependent where essn = ssn)

Answer

select fname from employee, department where dno=dnumber and not exists (select * from dependent where essn = ssn)

Answer

select fname from employee, department where mgr_ssn=ssn and not exists (select * from dependent where essn = ssn)

Crowdly

An SQL statement to display the first name of the employees who is a department ...

Want instant access to all verified answers on moovit.vit.ac.in?